|Subject||RE: [IBO] Refresh question|
> 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.
> 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
IF( (new.AC_ID IS NULL) OR (new.AC_ID < 1) )THEN
new.AC_ID = Gen_ID(GEN_AC_NEW_ID, 1);
SET TERM ; ^^
Thus, I think my problem must be in the application code.
Comvision Pty. Ltd.