>Is there a place on the web for a good ref. for SPT SQL syntax? I am converting some old VFP stuff using SPT and the same syntax doesn't work. Unfortunately this is my first project using ODBC and SPT. I looked through the help file and didn't find very much info.
>
>I am using ODBC and VFP tables (DBC).
>
>Also, is the syntax the same for SPT no matter what ODBC driver you use? IE: If i switch to SQL Server for the back end will I have to modify my SPT commands?
No. With SPT you are sending a literal string to a back-end database, which it then interprets and (hopefully) executes. You must format the string so the back-end understands it.
Most back-ends are ANSI SQL compliant (e.g. SQL-92) but this is not universal, and they all have their own foibles. In short, different back end, (often) different SPT.
This is a good reason to use n-tier design and set up a data access tier, to limit the places you have to make changes if your back-end changes.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up