>BEGIN TRANSACTION and END TRANSACTION are VFP commands that affect VFP tables. They have no impact on SQL Server. Check out SQLSetProp and specifically the Transactions property for controlling remote transactions.
Just to clarify, BEGIN TRANSACTION is a valid SQL server, END TRANSACTION is not, it should end in either COMMIT or ROLLBACK and they can be used from FoxPro as long as they are on the same connection
Hugo
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges