Arn,

> Two days ago I have switched from Firebird 1.5.3 to Firebird 2.0.3.
> I have a lot of databases.
> In few of them generators not advance anymore.
>
> These db's have a long history of " NO PROBLEM " running.
> After change the server,
>
> the trigger:
> ** ---------------------------------------------------
> begin
> if ( new.mycode is nul l) then
> new.mycode = gen_id( gen_comuni_id, 1 );
> end
> ** -----------------------------------------------------

Please confirm that the trigger is a BEFORE INSERT or BEFORE UPDATE
trigger.


Sean