>>>Do you need SQLSETPROP(oApp.oVar.sqlHandler,"Transactions",DB_TRANSMANUAL)
>>>
>>>Suhashegde
>>
>>Yes, if you want to save ALL records or none.
>>
>>About 90% of time the user works with ONE table, that is why I leave TRANSACTIONS to be AUTOMATIC. but In that class I need to save either ALL records either NONE of them.
>
>Then what would SQLEXEC(handle,"Commit Transaction") DO ?

Just commit all changes I sent back to SQL Server.
This is something like:

BEGIN TRANSCATION
* Make Change in Table1
* Make Change in Table2
* Make Change in Table3
.....
* Make Change in TableN
IF SomethingNotGood
   ROLLBACK && Roll back ALL changes made in ALL tables
ELSE
   COMMIT && We have success. The save ALL changes.
ENDIF

in VFP.