Subject Strange error trigger line 11 but triger have 7 lines ..
Author karolbieniaszewski
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