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 < [email protected]> 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] ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
