>I am in the process of converting a VFP app to SQL Server database.
>
>I have a routine (sort of business object) that updates several tables and within each table several records. Some process involves comparing values in a VFP cursor against values in the database tables and then making changes to the database table fields.
>
>I don't want this routine to be in a stored procedure. All code should reside in VFP with SQLEXEC calls getting and setting values to the tables and records. Of course, I have to rewrite the entire code because the current VFP code is not structured for SQL Server database.
>
>How do I create a BEGIN TRANSACTION / END TRANSACTION with a bunch of calls to the database with SQLEXEC that would either retrieve or update some tables and records?
>
>Any suggestions would be appreciated.

Use table buffering on all tables. Make changes to all tables. Then do something like:

llsuccess = .t.
begin transaction
if m.llsuccess and not tableupdate("table1")
aerror(gaError)
llsuccess = .f.
endif
if m.llsuccess and not tableupdate("table2")
aerror(gaError)
llsuccess = .f.
endif
if m.llsuccess
end transaction
else
rollback
*display error
endif