When I close the transaction, the query always will be closed. But when the
transaction closes automaticly (because of the TimeOutProps) the query stays
open. Exists a way to close the transaction 'manually' without closing the Query
?


Guido.

Jason Wharton wrote:

> 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.
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> >
> >
> >
> >
> >
>