|Subject||Re: [IBO] Questions about transactions and generators|
At 11:46 AM 22/05/2004 +0200, you wrote:
>Helen Borrie wrote:Too true. :-))
> > 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...