>I am using SPT in some places to insert/update. Some of these statements are being sent seperately & not as a batch. There are some VFP stmts inbetween. I have not changed the default SQL Server environment.
>
>Is it possible to make a transaction over multiple SqlExec() calls?
Hi Aman.

Try this.

?SQLSETPROP(lnHandel,"Transactions",2)
* sptexec() here 
if sqlcommit(lnHandel) < 0
  lnErro = aerror(laErrors)
  sqlrollback(lnHandel)
endif