Im doing a startTransaction... Then if something happens, Im calling a
rollback.

The next time I call my routing, it again calls a starttransaction. I get an
exception that says that a transaction is already being used (or something
like that)
I found that by simply doing a commit after my rollback, it works perfect
now. BTW, this is after calling a stored procedure, using a TIB_cursor ..


Gordon Hamm

----- Original Message -----
From: "Jason Wharton" <jwharton@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, August 01, 2001 2:34 PM
Subject: Re: [IBO] Confused about rollbacks etc..


> Why are you making that observation?
> Are you watching the sql trace monitor?
> Are you aware of the CommitAction setting of the datasets? They can cause
a
> new transaction handle to be acquired from the server if they are
> repositioning a cursor after a commit.
>
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
>
> ----- Original Message -----
> From: "Gordon Hamm" <vds@...>
> To: <IBObjects@yahoogroups.com>
> Sent: Wednesday, August 01, 2001 11:19 AM
> Subject: [IBO] Confused about rollbacks etc..
>
>
> > Hi,
> > It seems that you must call a commit after a call to rollback or the
> > transaction is not canceled. Is that true?
> > Im not sure why you would need to commit data if you rolled it back? Can
> you
> > explain?
> >
> > Gordon Hamm
>
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>