Subject | Re: [IBO] Record was not located to update |
---|---|
Author | Geoff Worboys |
Post date | 2001-08-07T12:15:27Z |
> My users get _sometimes_ this error when editing dataIs there any chance the key value of the record is being on the server
> in grid. What can cause it?
(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