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

Reply via email to