select statement with no return

[oliver]

Hello,

first i thought its a problem in the sql syntax, but plsql returned the information what i want, so i tried a new form in borland with a smartquery and added the following sql statement to it:

Code: Select all

select * from article a join subject s on a.id = s.article_id " + 
      "join keyword k on s.keyword_id = k.id where upper(k.keyword) = upper('faq') and a.deleted = 0");

the same happened here... i can't step into the execute() method and nothing happens...

i'm using borland 6 with odac 5.55.1.24 and Oracle9i Release 9.2.0.6.0

lg

Oliver

[Oliver]

Hello again,

looks like a interpretation failure in borland or odac.
if i change "select * from" to "select a.* from" it works.

lg

oliver