Re: [Firebird-net-provider] Active transactions?

[Ivan A. <int...@un...>]

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
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


-- 
Using Opera's revolutionary email client: http://www.opera.com/mail/