Hi, I haven`t used scripts in a while but I think if it fails to Commit it will throw an exception ...
> 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 -- Using Opera's revolutionary email client: http://www.opera.com/mail/ ------------------------------------------------------------------------------ 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
