The compiler Firebird swears at the string in the trigger

Question

CREATE TRIGGER my_before_trigger FOR MY_TABLE BEFORE INSERT AS BEGIN IF (NEW.my_number IS NULL) THEN NEW.my_number = GEN_ID(MY_GENERATOR, 1); END;

Swears at the sixth line (Unexpected end of command). What is the error code?

Gorets gorets 12k one 15 41 · Accepted Answer · 2012-04-23T14:55:19

 SET TERM || ; CREATE TRIGGER my_before_trigger FOR MY_TABLE BEFORE INSERT AS BEGIN IF (NEW.my_number IS NULL) THEN NEW.my_number = GEN_ID(MY_GENERATOR, 1); END || SET TERM ; ||

The compiler Firebird swears at the string in the trigger

1 answer 1

More articles: