I have not tested heavily all the cases where changing IB_Transaction
references with prepared queries. It takes a transaction handle to prepare a
statement but then after the transaction has been ended the statement's
prepare remains valid. So, if you are swapping around transactions I am
leaving statements prepared with their former transaction. I am assuming
this should be fine but there could be circumstances it causes a problem.

If you can provide me with a reproducible test case I will look at it.

Regards,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "G.Allen Casteran" <allen@...>
Newsgroups: egroups.ibobjects
To: <IBObjects@yahoogroups.com>
Sent: Saturday, September 21, 2002 1:51 PM
Subject: Re: [IBO] Problem in BindingCursor ??


> That makes sense.
>
> I made one change to the process and the problem went away.
>
> Within the process I had a query attached to the transaction in question
> that selected records. After I was done with the query, but before
> committing the transaction, I set the query's IB_Transaction property to
> nil. Then when I committed the transaction the error occurred. Looking
> at my code I assumed that clearing the transaction link from a query
> was not a good idea while the transaction was still active.
>
> After stopped clearing the IB_Transaction property the problem stopped
> occurring.
>
> Do you think that was indeed the cause or should I still be looking more
> closely at my datasets?
>
> Thanks,
>
> Allen.
>
> In article <012a01c24aaf$b6e83a40$dc756a41@CX170673E>,
> jwharton@... says...
> > It's having some kind of problem synchronizing your buffers. I suspect
> > because you have datasets without a proper KeyLinks assignment. I'd need
> > more information to know for sure. Please debug into it and share some
> > details.
> >
> > Regards,
> > Jason Wharton
> > CPS - Mesa AZ
> > http://www.ibobjects.com
> >
> > -- We may not have it all together --
> > -- But together we have it all --
> >
> >
> > ----- Original Message -----
> > From: "G.Allen Casteran" <allen@...>
> > Newsgroups: egroups.ibobjects
> > To: <IBObjects@yahoogroups.com>
> > Sent: Friday, August 23, 2002 12:58 AM
> > Subject: [IBO] Problem in BindingCursor ??
> >
> >
> > > I am getting this error reported when I run PostingTransaction.Commit.
> > > PostingTransaction is a TIB_Transaction linked to my queries and procs
> > > during a long posting process. It worked on 1 pass and then failed on
> > > the next 2.
> > >
> > > What does this mean and what's a likely cause?
> > >
> > > Thanks,
> > >
> > > Allen.