Hi.

Which is the best way to use Transactions in MS-SqlServer?

OPTION A)

ConectionId = SqlStringConnect("blá blá blá")
SqlSetProp(blá blá blá)
SqlExec(blá blá blá)
SqlExec(blá blá blá)
SqlExec(blá blá blá)
SqlCommit(blá blá blá) [or] SqlRollback(blá blá blá)

OR...

OPTION B)

ConectionId = SqlStringConnect("blá blá blá")
SqlExec("BEGIN TRANSACTION")
SqlExec(blá blá blá)
SqlExec(blá blá blá)
SqlExec(blá blá blá)
SqlExec("COMMIT") [or] SqlExec("ROOLBACK")

?

Thanks!