Is ADO Connection object in transaction?

[BrianB]

Hi folks,

When I build complex databases, I usually use a global connection object and leave it open. While in theory every time I begin a transaction, I also commit it or roll it back, errors happen. I want to test if the connection is in the midst of a transaction without rolling it back or committing it. There doesn't seem to be any kind of "is in transaction" property. Any ideas?

Thanks in advance.

-Brian

 

[hmckillop]

Maybe a bit simple, but use a boolean to store if the transaction is been opened

i.e.
public mblnIsTransactionOpen as boolean

if mblnIsTransactionOpen then
'cant set transaction error message as transaction
'already opened
else
dbConn.BeginTrans 'begin transaction
mblnIsTransactionOpen = true
end if

dbconn.rollbacktrans
mblnIsTransactionOpen = false

etc.