Subject Re: [IBO] insertSQL Help please
Author Helen Borrie
At 04:30 PM 8/03/2004 -0400, you wrote:
>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.