Subject | Re: [IBO] Record not located to update |
---|---|
Author | Babari Saloufou |
Post date | 2004-10-12T21:28:48Z |
> At 10:40 PM 21/07/2004 +0000, you wrote:Hi all,
> >A user got a "record was not located to update" exception. I don't
> >know what dataset it was on or why nor am I able to reproduce it. I
> >do have m/d datasets. What might I be doing wrong?
>
> Trying to post an update to a record that has been inserted in the same
> transaction?
>
> Helen
>
>
I have the same problem.
The problem occurs when you try to delete or post an update to a record
that you just inserted in an IB_GRID and if the primary key is bound on a
generator.
You can test this with the sample projet book.dpr and the database
ibook.gdb.
if you insert a book using the IB_GRID you can't immediatetely update or
delete it.
If you look carefully you will see TWO record in fact one on the top
(provided you were on top before inserting) and one
in the bottom.
You can delete or update the one in the bottom.
May be it's a problem of synch of the buffer with the IB_GRID
I solve the problem by doing a refresh of the query by mean of the after
post event.
Babari.