Hello Karol

Are you not using SET TERM?

There can be the additional lines.

Greetings.

Walter.



On Wed, Feb 29, 2012 at 5:46 AM, 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
>
>
>

[Non-text portions of this message have been removed]