Martijn Tonies wrote:

>
>
>
> > Sean:
> > this is the code:
> >
> > // -------------------------------------------------------
> >
> > CREATE OR ALTER trigger comuni_bi for comuni
> > active before insert position 0
> > as
> > begin
> > if (new.mycode is null) then
> > new.mycode = gen_id(gen_comuni_id,1);
> > end
> >
> > // ----------------------------------------------------------
> >
> > Martijn:
> > if I do:
> >
> > select gen_id( gen_comuni_id,1 ) from rdb$database
> >
> > Give Me GEN_ID=1
>
> And if you do it again? Does the value increase?
>
> It probably does. It really has to be in your application code
> or trigger code.
>
> Ok.

Yes, Martijn. It increase in result: BUT not in generator list. i.e.
gen_comuni_id= is the same before and after....

very strange however...

Arn