Unfortunetly this is not that case trigger is linked to good table and i never change it
Karol Bieniaszewski --- In [email protected], "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 [email protected], "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 > > >
