Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
No ANSI 92 Join Syntax Using OLE DB Provider w/ Crystal
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
No ANSI 92 Join Syntax Using OLE DB Provider w/ Crystal
Miscellaneous
Thread ID:
00728715
Message ID:
00728715
Views:
77
Hi Everyone,

I recently switched from ODBC to OLEDB data sources in all of my Crystal reports that access VFP8 databases. After the switch, I noticed that the SQL query returned from the OLEDB provider does not use ANSI 92 SQL syntax for joins. Rather, tables are joined in the where clause of the SQL SELECT... statement. ODBC returns ANSI 92 compliant join syntax, why doesn't OLEDB?

TIA,
Jeff
Next
Reply
Map
View

Click here to load this message in the networking platform