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.

Arn