Yes, if the CommitAction of a dataset is not caClose then it will cause the
transaction (physically only) to be acquired again.

If you want to force a transaction closed simply call it's Close method. If
AutoCommit is true it will perform a Commit of not it will perform a
Rollback. Calling CloseWithConfirm will prompt to Close the query and
EndWithConfirm will prompt and allow the Dataset's CommitAction to take
place.

It's all been thought of already, I just got to get people in the habit of
asking about it...

Actually, I just need to document it all.... <g>

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

----- Original Message -----
From: <guido.klapperich@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, February 12, 2001 7:08 PM
Subject: Re: [IBO] IB_Query.CommitAction


> Let me see, if I understood it the right way:
> caClose: Closes the Query
> caRefresh: Refreshes the Query after commit. But will this not start the
> transaction again ?
> caFetchAll: Sorry, no idea
> caInvalidateCursor: In short words, all stays as it is. The Query keeps
open,
> but the Transaction is closed.
>
>
> Guido
>
> Jason Wharton wrote:
>
> > They are self explanatory. When the transaction commits that is the
action
> > the datasets do. perhaps the only one that isn't totally clear is
> > caInvalidateCursor. What that is intended to do is try to preserve as
much
> > of the existing situation as possible without imposing extra work. If
the
> > dataset has fetched part way through the dataset it won't fetch any more
> > records and it won't refresh until it is accessed again.
> >
> > HTH.
> > Jason Wharton
> > CPS - Mesa AZ
> > http://www.ibobjects.com
> >
> > ----- Original Message -----
> > From: <guido.klapperich@...>
> > To: "ibobjects@egroups.com" <IBObjects@yahoogroups.com>
> > Sent: Monday, February 12, 2001 6:38 PM
> > Subject: [IBO] IB_Query.CommitAction
> >
> > > Can anybody explain me the different values of the
> > > IB_Query.CommitAction-Property ? The OH says nothing about it.
> > >
> > >
> > >
> > > Guido.
> > >
> > >
> > >
> > >
> > >
> >
>
>
>
>
>