Trigger Previous topic Chapter index Next topic

FEIERTAGE_INS

 

Beschreibung

Trigger um den Primary Key zu setzen.

 

Definition

CREATE TRIGGER FEIERTAGE_INS FOR FEIERTAGE
ACTIVE BEFORE INSERT POSITION 0
AS 
BEGIN 
  IF (NEW.FGID IS NULL) THEN 
     NEW.FGID = GEN_ID(FGID_GEN, 2);
END

 

     Previous topic Chapter index Next topic