|Re: [IBO] 3.6.Dd
> If the grid is left untouched for a few minutes itThis will probably be the transactions OAT automation. I think ONE of
> automatically updates and I now have 6 records in
> the grid.
the following will help...
* If you the transaction isolation to tiConcurrency (the default) then
you will stop the query from seeing the results of other
transactions - you will also disable the OAT automation, so you must
manage that for yourself.
* Disable OAT automation for that transaction - set
IB_Transaction.TimeoutProps.Attempt := 0;
* Setup the query so that CommitAction is set to caFetchAll, and also
set AutoFetchAll to true. In that way, when the transaction tries to
commit and performs a FetchAll, there is nothing left to fetch so