--- In firebird-support@yahoogroups.com, "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