Unfortunetly this is not that case
trigger is linked to good table and i never change it

Karol Bieniaszewski

--- In firebird-support@yahoogroups.com, "nathanelrick" <nathanelrick@...> wrote:
>
> 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
> >
>