SQL Builder Generates a Syntax Error 
Author Message
 SQL Builder Generates a Syntax Error
I'm using VB 6 Professional and the query builder invoked from the Data
Environment generates a syntax error for join operations.  For example:

SELECT Customers.*, Orders.* FROM { oj Customers LEFT OUTER JOIN Orders ON
Customers.CustomerID = Orders.CustomerID }

For some reason, it is adding the "{ oj" and "}" around the FROM part and
that is an error.  Has anyone a solution to this?

Jim Thompson



Tue, 09 Dec 2003 06:52:53 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. SQL Builder Generates a Syntax Error

2. SQL generated Syntax error when upsizing the following query

3. Code error generated by screen builder in 2.6

4. SELECT syntax error - unable to generate data set from data adapter

5. ALTER COLUMN generate SYNTAX error

6. SQL syntax builder tools

7. Syntax error w/ no error in syntax.

8. Command line syntax for generating SQL Scripts

9. PowerDesigner 6: Bad SQL Syntax generated !

10. Q:SQL syntax for generating sequential numbers in a recordset

11. Beta: SQL::Builder -- an OO SQL builder Perl module

12. Query Builder or SQL Builder


 
Powered by phpBB® Forum Software