Subject | Re: open transaction |
---|---|
Author | Rick Roen |
Post date | 2006-01-06T00:58:53Z |
> Transactions are not posted. DML statements are posted within atransaction.
My mistake. I posted the TIB_Query which was attached to the
TIB_Transaction.
Here's what I wanted to achieve: The user posts a batch of new
records via a TIB_Query. Then the TIB_Transaction is waiting to
Commit. I want to notify the user that they need to commit if they
wait too long, or take over eventually for their lack of attention.
Do these settings operate under these circumstances, or should I
just set a timer and prompt from that?
Rick
>the
> I'm not clear about what you want to achieve by this. You have
> transaction in WAIT resolution, which means that a DML statementrequest
> could be hanging in an"unposted' state, waiting for anothertransaction to
> finish. The application won't know whether the post is going tosucceed or
> fail until (or unless) it receives an exception. That can'thappen until
> the other transaction either commits or rolls back. TimeoutPropsoperate
> on idle transactions. If your transaction is waiting for itsrequest to be
> executed then it's not idle.
>
> Helen
>