>Hi ALeksey
>
>>Just to make it clear, SQLSETPROP(connectionhandle,"Transactions",2) is equivalent to BEGIN TRANSACTION.
>
>Is that really correct? After issuing
>SQLSETPROP( connection, "Transactions", 2 )
>
>The query: SQLEXEC( connection, 'SELECT @@TRANCOUNT' )
>returns 0 and certainly there is no behavior to suggest that a transaction has been started.
>
>However, if I use: SQLEXEC( connection, 'INSERT INTO....' )
>Then check the transaction count, I see '1', as expected.
>
>I thought that all that setting the transactions property of the connection
>to "manual" does is to require that the client must explicitly close implicit transactions with SQLCOMMIT/SQLROLLBACK?

... and wouldn't it be nice if you could find the answers to this and many other similar questions within the VFP docuemntation?!?!