Subject | Re: [IBO] Questions about transactions and generators |
---|---|
Author | Helen Borrie |
Post date | 2004-05-22T03:26:13Z |
At 01:13 PM 22/05/2004 +1000, you wrote:
Insert trigger if you have not done so already, viz.
IF (NEW.MyTablePK <> NULL) THEN
NEW.MyTablePK = GEN_ID(GenMyTable, 1);
>Helen,Yes; and I should also have mentioned that you must clean up your Before
>So, to clarify my understangin of GeneratorLinks:
>Where GeneratorLinks are used, IBO is using GenId() to grab the generator
>value, then explicitly setting the PK columns value on the client side,
>rather than relying on a GenId() in a BeforeInsert trigger to update the PK?
Insert trigger if you have not done so already, viz.
IF (NEW.MyTablePK <> NULL) THEN
NEW.MyTablePK = GEN_ID(GenMyTable, 1);