Thanks Helen,

but when I use New.IDLOC is NOT NULL
I get an error;
Validation Error for Column IDLOC, value ****null*****

is there something else to set? I have generatorlinks
IDLOC=GEN_LOCATIONS_IDLOC

Daniel

--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
> At 04:30 PM 8/03/2004 -0400, you wrote:
> >Thanks,
> >
> >I do not see 2 blank rows, only the generator gets inc by 2. I have
> >generatorlinks set, would that cause it? if generatorlinks is set
I do
> >not need a trigger?
>
> Your trigger needs to be
> if (new.ID is not null) then
> new.ID = gen_ID (your_generator, 1);
>
> The null test is essential if you are using generatorlinks, to
avoid firing
> the trigger when you already have the value.
>
> Helen