SET TERM !! ; CREATE TRIGGER SET_CUSTOMER_CUST_ID FOR CUSTOMER BEFORE INSERT AS BEGIN IF (NEW.CUST_ID IS NULL) THEN NEW.CUST_ID = GEN_ID(CUSTOMER_CUST_ID_INC, 1); END !! SET TERM ; !!
CREATE GENERATOR CUSTOMER_CUST_ID_INC; SET GENERATOR CUSTOMER_CUST_ID_INC TO 0; SET TERM !! ; CREATE TRIGGER SET_CUSTOMER_CUST_ID FOR CUSTOMER BEFORE INSERT AS BEGIN IF (NEW.CUST_ID IS NULL) THEN NEW.CUST_ID = GEN_ID(CUSTOMER_CUST_ID_INC, 1); END !! SET TERM ; !!