No triggers. It sometimes happens when I work alone.


Riho-Rene Ellermaa
senior programmer
Hansabank

> -----Original Message-----
> From: Geoff Worboys [mailto:geoff@...]
> Sent: Tuesday, August 07, 2001 2:15 PM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] Record was not located to update
>
>
> 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.
>
>
>