hi,
You didnt understand what i was saying,

SQLSETPROP(oApp.oVar.sqlHandler,"Transactions",DB_TRANSMANUAL)
Would need SQlcommit() and sqlrollback() to be effictive

Would SQLEXEC(handle,"Commit Transaction") alone be more than sufficient ?

Try it with the codes i posted.

thanx,
Suhashegde

P.S.: Just saw that you were using both. Both start at the same place and end at the smae place. No updates are sent to server in between them. So sqlsetprop would be a unnecessary call. And Also would increment @@Trancount unnecessarily