Subject Re: [IBO] insertSQL Help please
Author newgen3152003
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


--- In, 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