I don't understand what you mean. It is not the provider that writes the SQL Statement, but Crystal? Or am I missing your point?
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only