Subject Re: [IBO] Can't update on TIB_Grid
Author Jason Wharton
> I have a table with Primary Key filled (assigned) by the server on a
> trigger.
> (BEFORE INSERT, ID=unique value ...)
> Then, when I make new records on a Grid, all rules ok, and the records
> appears as new rows (without ID).
> But if I try to modify a row, I get "cannot locate record" error, because
> they haven't ID.
> After refresh, or close&open, the ID has value, and update is now
possible.
> Is there any way to avoid this?

You need to provide the ID prior to posting the INSERT to the server. If the
server provides the ID in a trigger then the client knows nothing about it
and cannot any more identify the row.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com