Trigger Previous topic Chapter index Next topic

EINSTELLUNG_BEFORE_INS

 

Beschreibung

Trigger um den Primary Key zu setzen.

 

Definition

CREATE TRIGGER EINSTELLUNG_BEFORE_INS FOR EINSTELLUNG
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
  IF (NEW.EGID IS NULL) THEN 
    NEW.EGID = GEN_ID(EGID_GEN, 2);
END

 

     Previous topic Chapter index Next topic