Subject | Re: Isolating TransActions |
---|---|
Author | anthpjc |
Post date | 2004-03-02T06:23:12Z |
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.
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