[Firebird-net-provider] Active transactions?

[Perry C. <peg...@ho...>]

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.