I don't know if it can help but

when you do CREATE TRIGGER TRIG_OPIS_DB_ID FOR OldTable ACTIVE
that ok

but after, you see you make a mistake, and you do

Alter Trigger TRIG_OPIS_DB_ID FOR AnotherTable ACTIVE
...

THEN (i don't know if it's a bug or not) the trigger stay connected to the OldTable ...

so probably you are here mixing the trigger ?

i have the same probleme with strange trigger error still i discover that trigger was connected to the wrong table

--- In firebird-support@yahoogroups.com, "karolbieniaszewski" <liviuslivius@...> wrote:
>
> Hi,
>
> ocassionally i got this error
>
> Database server error:
> arithmetic exeption, numeric verflow, or string truncation At trigger 'TRIG_OPIS_DB_ID'
> line: 11, col: 3
>
>
> but trigger look like
> CREATE TRIGGER TRIG_OPIS_DB_ID FOR OPIS_DB ACTIVE
> BEFORE INSERT POSITION 0
> AS
> BEGIN
> IF ((NEW.ID IS NULL) OR (NEW.ID=0)) THEN
> NEW.ID = GEN_ID(OPIS_DB__ID_GEN, 1);
> End
>
> as you can see this trigger have 7 lines not 11
> and also i do not see any option to string truncation, numeric overflow or arithmetic exception ..
>
> generator velue is now 6289 ..
>
> any advice
> Karol Bieniaszewski
>