Subject Re: [IBO] Rollback
Author Jason Wharton
Ah ha! I see. I thought I had it setup to be published there but apparently
I don't. I will add it to the published section.

The reason you are seeing the behavior you are is due to the setting of this
property internally to caInvalidateCursor. What this does is cause a refresh
to take place for you if the transaction is going to commit or rollback. If
all the records have been fetched from the cursor then there is no need for
the transaction to close the cursor and have it refreshed to restore it.

You can set it to something else by using
MyIBOQuery.InternalDataset.CommitAction := caRefresh. Then, every time there
is a Commit or Rollback the dataset will refresh as you are expecting.

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


----- Original Message -----
From: <hans@...>
To: <IBObjects@yahoogroups.com>
Sent: Saturday, August 11, 2001 3:46 PM
Subject: Re: [IBO] Rollback


> On a TIB_Query, I can find a CommitAction property,
> but I can't find one on what I use, namely TIBOQuery.
>
> ===================================================
>
>
> Jason Wharton wrote:
> >
> > There is property on the datasets called CommitAction. What is it?
> >
> > Jason Wharton
> > CPS - Mesa AZ
> > http://www.ibobjects.com
> >
> > ----- Original Message -----
> > From: <hans@...>
> > To: <IBObjects@yahoogroups.com>
> > Sent: Saturday, August 11, 2001 3:07 PM
> > Subject: Re: [IBO] Rollback
> >
> > > In order to Transaction.RollBack, I have then set as follows:
> > >
> > > TMSServer.Connected := False;
> > > IBOTransaction.AutoCommit := False;
> > > IBOTransaction.Isolation := tiCommitted;
> > > IBOTransaction.ServerAutoCommit := False;
> > > ...
> > > DataBaseName and Password stuff
> > > ...
> > > TMSServer.Connected := True;
> > >
> > > Best regards
> > > Hans
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>