Subject Re: [IBO] Record was not located to update
Author Geoff Worboys
> My users get _sometimes_ this error when editing data
> in grid. What can cause it?

Is there any chance the key value of the record is being on the server
(by a trigger)?

That is; IBO relies upon the key values to locate the record for
updating. If the key was changed by a trigger when it was inserted
then the key that IBO is using will not be able to locate that record.

Perhaps (using tiCommitted transaction isolation) someone has come in
from a different session and changed the record, so that the key in
the buffer is no longer valid. This is one of the big reasons for
using surrogate keys, they never need to be changed after originally
created.


HTH

Geoff Worboys
Telesis Computing