Subject Re: [IBO] Questions about transactions and generators
Author Helen Borrie
At 11:46 AM 22/05/2004 +0200, you wrote:
>Helen Borrie wrote:
>
> > Yes; and I should also have mentioned that you must clean up your
> > Before Insert trigger if you have not done so already, viz.
> >
> > IF (NEW.MyTablePK <> NULL) THEN
> > NEW.MyTablePK = GEN_ID(GenMyTable, 1);
>
>Make that: IF (NEW.MyTablePK IS NULL) THEN...

Too true. :-))

Helen