VB 4.0, ANSI SQL '89, complex queries? 
Author Message
 VB 4.0, ANSI SQL '89, complex queries?

Can VB 4.0 perform complex, sophisticated SQL queries using only
the Jet 3.0 engine?

I see in the documentation that VB/Jet supports ANSI SQL, circa 1989,
excluding transactions and combining DISTINCT with aggregate
functions.  Does it really?

Has anyone tried any sophisticated nested queries, or complex
multitable joins (3 or 4 tables) who can comment on how well
the Jet 3.0 engine works?

I realize VB 4.0 is best coupled with Oracle, SQL-server, etc.,
but all I will have for a while is VB 4.0...


 "Visit the Hydrologic Information Center at http://www.*-*-*.com/ ~hic"

Sun, 19 Apr 1998 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. How do I do this with sql 89?

2. SQL's with complex queries

3. Q: MS SQL queries -> ANSI SQL

4. Q: MS SQL queries -> ANSI SQL

5. Image Controls that handle GIF 89?

6. Total bytes downloaded varies using mswinsck.ocx ( on win2k

7. complex SQL query

8. Complex SQL Query...HELP!

9. complex SQL query

10. Complex SQL query

11. Need help with complex SQL query

12. Complex SQL Query: HELP!


Powered by phpBB® Forum Software