Subject | RE: [IBO] Refresh question |
---|---|
Author | Daniel Jimenez |
Post date | 2004-12-10T01:11:16Z |
> Generally, this is caused by having both a trigger on theHi Woody,
> insert of the table and a generator link in the code portion
> handling your inserts. Since you want IBO to take care of
> incrementing the generator (setting the GeneratorLinks
> property), if a trigger also exists, but doesn't test for a
> value already in the field, it will also increment the generator.
>
> HTH
> Woody (TMW)
>
You are 100% right, I have just check my trigger definition:
SET TERM ^^ ;
CREATE TRIGGER T_AC_NEW_ID FOR ALARMCODES ACTIVE BEFORE INSERT POSITION 0 AS
BEGIN
IF( (new.AC_ID IS NULL) OR (new.AC_ID < 1) )THEN
new.AC_ID = Gen_ID(GEN_AC_NEW_ID, 1);
END
^^
SET TERM ; ^^
Thus, I think my problem must be in the application code.
Thank you
daniel
____________________________
Comvision Pty. Ltd.
www.comvision.net.au