Hi Robert,

> Sorry about the long winded email to ask a fairly simple
> question :)

Yes IBO does often create SQL to locate the value of the key,
which it then tries to locate in its buffers or retrieve
from the database. However, if I remember correctly, it will
only do this if the query is not finished (has not loaded all
the rows into its buffer).

So, whatever else, you must do a FetchAll after open to
ensure that you have copies of all the "old" rows in memory.
(The default behaviour is to only load rows as needed.)

Not sure... but you may also try clearing the KeyLinks, as
this will definitely force IBO to work through its buffers
rather than trying to match a row directly.

All that aside, tiConcurrency is probably the most reliable
solution - although I am guessing you want this to be a long
running transaction.

--
Geoff Worboys
Telesis Computing