Subject Re: [IBO] Transaction.
Author Geoff Worboys
> Transaction1.InTransaction
> Query.Insert;
> Query.FieldByName('Credit').AsString := '052';
> Transaction1.PostAll;
> Transaction1.CommitRetaining;
>
> Other user (terminal) not look, because ?

I presume you mean that the other user cannot see the record that was
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