Subject Re: Isolating TransActions
Author anthpjc
i've figured it out and it was due to a stored procedure that i had
running somewhere in between that uses the infamous transaction.
Thanks for your help and sorry for wasting your time.



--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
> At 02:39 AM 2/03/2004 +0000, you wrote:
> >hi helen,
> >I am using transactionsources so that i may use the OnStatusChanged
> >event for when the transaction changes state.
>
> What are you actually *doing* in this event? What are you using the
> ib_transaction source *for*?
>
>
> >The main point i'm unsure of is why, in my previously posted example,
> >the transaction state changes and the OnStatusChanged event of the
> >transactionsource is invoked if i'm inserting with a query that is not
> >assigned with that transaction/transactionsource in any way.
>
> I cannot guess, other than you are doing something in that handler that
> impacts the whole session. So what is the handler doing?
>
> You can read TransactionState from the transaction and get much
closer to
> the action.
>
>
> Helen