| Subject | Re: [IBO] Questions about transactions and generators |
|---|---|
| Author | Helen Borrie |
| Post date | 2004-05-22T09:54:05Z |
At 11:46 AM 22/05/2004 +0200, you wrote:
Helen
>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...
Helen