SQL Builder - Outer Joins. 
Author Message
 SQL Builder - Outer Joins.

Im using the VB6 Data Designer to create recordsets from an MS Access
I am "trying" to use the SQL Builder.
Whenever I set a table join to an Outer Join, The SQL Builder creates the
SQL statement in Oracle format with the "{ oj " indicator at the begining of
each join.
When I do a 'Verify SQL', SQL Builder reports a syntax error in the FROM
clause and the query will not run.
If I remove the '{ oj ' indicators everything works Ok.
However, if I make any change to the query,  SQL Builder puts all the
incorrect syntax back in.
The Connection Data Provider is set to 'Microsoft Jet 3.51 OLE DB Provider'
so why does SQL Builder insist on generating the Oracle syntax for outer
joins then tell me the syntax is incorrect.
If I set the Data Provider to 'Microsoft OLE DB Provider for SQL Server' and
do an outer join on two SQL Server tables, the generated SQL syntax is Ok.
Thanks in anticipation.
Paul Thompson

Sun, 16 Dec 2001 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. SQL Builder - Outer Joins.

2. SQL Builder - Outer Joins.

3. sql poser: OUTER JOINS?

4. SQL error (outer join)

5. SQL statement on 2 or more tables (left outer joins)

6. Left Outer Join to SQL Server

7. AMBIGIOUS outer joins in my sql

8. Multiple Outer Joins using MS Jet SQL

9. Illegal Outer Join Error - SQL Guru Needed

10. Multiple Outer Joins using MS Jet SQL

11. SQL Syntax for an Outer Join

12. Query Builder or SQL Builder


Powered by phpBB® Forum Software