Trigger Interbase

[r_kerber]

Folgendes Beispiel findest Du in der OH von Interbase, Versuche es mal so!

SQL-Code:

SET TERM !! ;
CREATE TRIGGER SET_CUST_NO FOR CUSTOMER
   BEFORE INSERT AS
   BEGIN
      NEW.CUST_NO = GEN_ID(CUST_NO_GEN, 1);
   END !!

SET TERM ; !!