>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

Your select starts a transaction.

BOb