>Are there any help resources for ODBC ODBC syntax? For instance, when issuing 'SQLExec()' in VFP, single or double quotes work fine in VFP and in SQL, but ODBC chokes.
>I am looking for a help file or other reference material.
>
>Thanks
>Denis
I had a similar situation that I just resoloved. After a solid week of pulling my hair out (what little I have left, anyway) I think I came across the solution. After hours of research as to why a stored procedure runs OK by SQL directly but not thru my SPT statement, I finally came across a coulple of references to 'SQL quoted identifiers' which discussed ANSI spec compliance. Then I remembered that the ODBC connection setup has properties dealing with ANSI specs. I checked on the exact nature of quoted identifiers and then realized that I may have an incorrect ODBC setting.
In short, go to your ODBC settings and select to configure your connection. Ensure that the "Use ANSI quoted identifiers" is UNCHECKED. If enabled, this option tells SQL that the use of the double quotes is reserved for identifiying sql objects, such as table fields.
Re-establish your connection and give it a try.
Let me know if this helped!
Larry