Hi,

> 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
> ** -----------------------------------------------------
>
> do not works.
>
> gen_comuni_id is the generator which don't increment anymore.
>
> Sound very strange

Could it be that new.mycode simply is not NULL?

What happens if you perform a "select gen_id(...) from rdb$database"
from a query tool?

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com