Hello,

what is also interesting is that when you connect a transactions is already in progress... e.g.

SQLSETPROP(0,'Transactions',2)

LOCAL lnCon
lnCon = SQLCONNECT(yourSettings...)

?SQLEXEC(lnCon,'SELECT @@TRANCOUNT AS myTest','testres')
?"TransactionCount", testres.myTest

?SQLEXEC(lnCon,'COMMIT')
?SQLEXEC(lnCon,'SELECT @@TRANCOUNT AS myTest','testres')
?"TransactionCount", testres.myTest

?SQLEXEC(lnCon,'UPDATE someTable SET someField = 'someValue')

?SQLEXEC(lnCon,'SELECT @@TRANCOUNT AS myTest','testres')
?"TransactionCount", testres.myTest

?SQLEXEC(lnCon,'ROLLBACK TRANSACTION')
?SQLEXEC(lnCon,'SELECT @@TRANCOUNT AS myTest','testres')
?"TransactionCount", testres.myTest

&& settings implicit transactions off ..
?SQLEXEC(lnCon,'SET IMPLICIT_TRANSACTIONS OFF')

&& now not revertable ...
?SQLEXEC(lnCon,'UPDATE someTable SET someField = 'someValue')

?SQLEXEC(lnCon,'SELECT @@TRANCOUNT AS myTest','testres')
?"TransactionCount", testres.myTest

Regards

Christian