Subject [IBO] Re: How to use bookmarks like tTable and tQuery?
Author Svein Erling Tysvær
Hi Andrei, nice to see that Thomas helped you solve your problem. But
have you understood why your original design did not work?

It is simply that the bookmark is fetched from the client (and the
bookmark is somehow related to your primary key), then the trigger
sets or changes the primary key at the server, but doesn't tell the
client (triggers work only on the server). Your bookmark is no longer
valid, but the client doesn't know it.

Set

--- In IBObjects@yahoogroups.com, Andrei Luís wrote:
> CREATE TRIGGER TRIG_AGENDA_BI_0 FOR AGENDA
> ACTIVE BEFORE INSERT POSITION 0
> AS BEGIN
> NEW.REGISTRO_ID = GEN_ID(GEN_AGENDA_REGISTRO_ID,1);
> END
>
> > I was working on this and finally found the problem: I have one
> > trigger that feeds the PK field. I turn it INACTIVE and now I
> > have the behavior I want in application. I turn the trigger
> > ACTIVE, just for testing, and the pointer goes crazy again.