Charles,

Here is what I do.

SQLSETPROP(this.nconnection,"Transactions",DB_TRANSMANUAL) && 2
** do your stuff here. 
lnRet = SQLCommit(this.nconnection)
if lnRet < 0
* report error.
sqlrollback(this.nconnection)
endif 

>Hello all
>
>I have code which posts a series SQLEXEC update and delete queries against
>an "Adaptive Server Anywhere 8.0" database via ODBC.
>
>Does anyone know how to make the series transactional, post them all on none? I.E. are there @@ BEGIN and @@COMMIT @@ROLLBACK type commands before and after or does this involve SQL PREPARE ???
>
>I am a bit foggy on these concepts and I need a quick solution for my client.
>
>TIA
>Charles Richard