Subject | GENERATORS don't works anymore |
---|---|
Author | Arn |
Post date | 2007-12-17T17:28:27Z |
Hi All.
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
Anyone could help????
TIA
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
** -----------------------------------------------------
do not works.
gen_comuni_id is the generator which don't increment anymore.
Sound very strange
Anyone could help????
TIA
Arn