--- 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 >
Hi, finally i found the problem! My client modify this simple trigger and add code !@^! Karol Bieniaszewski
