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 >
