Subject | Re: [IBO] Transaction. |
---|---|
Author | Geoff Worboys |
Post date | 2001-03-09T12:07:33Z |
> Transaction1.InTransactionI presume you mean that the other user cannot see the record that was
> Query.Insert;
> Query.FieldByName('Credit').AsString := '052';
> Transaction1.PostAll;
> Transaction1.CommitRetaining;
>
> Other user (terminal) not look, because ?
just posted? You need to check the transaction of the other user - if
they are not using Isolation=tiCommitted, they will not see any new
records until they start a new transaction. Whatever the isolation,
they will not see the new record until they have refreshed their own
query.
Check out the TransactionPausing tutorial - you may need to remove the
comments around some of the code before building. It shows two grids
side-by-side, operating off different transactions. The sample allows
you to experiment with the different isolations and see the impact.
HTH
Geoff Worboys
Telesis Computing