Arn wrote:

> Martijn:
>
> If i do:
>
> insert into t1( mycode, field1 ) values ( gen_id( gen_t1_id,1), 'test' )
> all works fine.
>
> Generator is incremented and mycode receive the RIGHT value
> Mycode is the Primary Key.
>
> So the problem IS NOT Firebird.
>

It's possible that the field isn't being passed to the trigger as being
NULL. If that's the case, the trigger will not set the field to the next
generator value. Have you tried testing for NULL or zero in the trigger
to see if that works?

Woody (TMW)