Hi all, Is there any way of determining if there is an active transaction being used by an FbCommand? I have searched the properties of FbCommand, FbConnection, FbTransaction, the net, and these forums but can find no answers.
I am using a FbScript component and I cant be sure if the last script run ends with a "commit" or not. If I try to commit a transaction that has already been committed I get a "This Transaction has completed; it is no longer usable." error. And if I try to start a transaction when there is already one active I get a "A transaction is currently active. Parallel transactions are not supported." error I'd be happy for an answer in any version of the provider. Am currently using 2.0 and trying 2.5. Having something like FbConnectionInternal.HasActiveTransaction publicly available is what I am after. Cheers, Perry -- View this message in context: http://firebird.1100200.n4.nabble.com/Active-transactions-tp4631687.html Sent from the firebird-net-provider mailing list archive at Nabble.com. ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
