> If the grid is left untouched for a few minutes it
> automatically updates and I now have 6 records in
> the grid.

This will probably be the transactions OAT automation. I think ONE of
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
nothing happens.


HTH

Geoff Worboys
Telesis Computing