🚀 go-pugleaf

Nick wrote:
> Just an update...
> I tried using different JDBC drivers and had no luck in using subqueries with 
QueryDataSet in JBuilder 2006.  I had to rewrite the Subqueries as Joins 
instead
and this seems to work. I am still not sure if it truelly is a JDBC 
driver issue
or a JBuilder issue.  I was unable to find any information regarding my 
particular
problem (running subqueries, 3 levels, wouldn't even work for 2 levels). 
To any
one else with similar issues, good luck, and write Joins instead.
> 

I don't know if you entirely understand the relationship between 
JBuilder and JDBC..

Basically there is none.. sort of..

The SQL Builder (which I never have used..) and DX are probably the only 
"interfaces" between JBuilder and JDBC..

I would 'ASSUME' that SQL builder sticks to a specific level of the SQL 
standard. So.. if you are including a database specific function(s), it 
will probably complain..

My experience (where I tend to do most of my work) with DX is that it 
does no validation and just passes the SQL through.  (There can be 
escaping issues..)

That leaves JDBC and that is the rub..  JDBC is ONLY an interface API to 
specific implementations by the various database vendors.

(Purchase a good JDBC book, that will do more to helping you on the 
"java/JBuilder" end than anything..)

Therefore, with the possible exception of the SQL Builder (which I 
never, ever use.. did I say that already..<G>) any issue with SQL and 
your database is ALWAYS a driver issue.  JBuilder could care less..

John..


-- 
=============================================
TeamB are volunteer helpers.  Please DO NOT REPLY VIA EMAIL!
Post all questions and replies to this newsgroup ONLY
For papers on DataExpress, Applets, JSP, and Web Development go to:
http://www.microps.com/mps/paperFAQ.html
====================================================