Hold on, I just re-read your original question.
Since you are using VFP tables via ODBC, I really don't know if SQLCOMMIT() will work. I know for a fact it won't work if you go straight to the tables, but since you are going through ODBC I really don't know.
>Hi Hector,
>
>They really should say in the help that SQLCOMMIT() does not work with a VFP database even through SPT.
>
>I will try what you said.
>
>Thanks
>Mike
Hector Correa