> Generally, this is caused by having both a trigger on the
> 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)
>

Hi Woody,

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