Subject | Strange error trigger line 11 but triger have 7 lines .. |
---|---|
Author | karolbieniaszewski |
Post date | 2012-02-29T09:46:15Z |
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
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