🚀 go-pugleaf

Hi,
I've just experimented with this. I got JB 2006 Ent, the same as Nick. I 
used classes12.jar against a 10G Oracle database.

The following SQL (which should work on virtually any Oracle database) runs 
happily in PL/SQL :-
select * from dual where dummy in (select dummy from dual)

The same statement also works fine in JB 2006's Database Pilot.

If you create a new datamodule and use the SQL builder to create the 
following SQL statement it works.
SELECT * FROM DUAL

Once you've created your QueryDataSet, go into design mode and select your 
QueryDataSet from the structure pane.
From the properties window, click on the 3 ellipses next to the Query 
property.
Now type in the original SQL with the nested subquery :-
select * from dual where dummy in (select dummy from dual)

Click the test query button and you should get "SUCCESS".

Now click the SQL Builder button and use the same SQL in the builder, this 
time you get an error parsing SQL. I think this probably suggests a problem 
with the builder rather than JDBC.

I think the moral is that as John says he avoids using the SQL Builder to 
construct the SQL. You could test it in the Database Pilot and paste it in 
from there.

Hope this helps.
Arth






"Nick" <nmperez@water.ca.gov> wrote in message 
news:45dc7fd2$1@newsgroups.borland.com...
>
>
> I appreciate everyones help on this topic. Will do on the JDBC book, I am 
> crash course learning JBuilder, so I appreciate the explanations.
>
> thanks again,
> Nick