DETECTING ACTIVE ADO TRANSACTION

[Bickle]

Does anybody have any ideas how to detect with ADO if there is a current transaction already started. In my error handling I need to detect this before I do a RollBack...

 

[bjd4jc]

I don't know of a way to check. But, you could set a boolean variable to true after you begin a transaction and then set it to false everytime you commit rollback.

If you declare your adodb object WithEvents then you can put this is then put this in the events.

 

[Bickle]

OK thanks, I thought of that option but I was hoping the ADO connection object had a property that could tell me if a transaction has already started....