Trigger

EXPORTS_BEFORE_INS

Beschreibung

Trigger um den Primary Key zu setzen.

Definition

CREATE TRIGGER EXPORTS_BEFORE_INS FOR EXPORTS
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
  IF (NEW.EXID IS NULL) THEN 
    NEW.EXID = GEN_ID(EXID_GEN, 2);
END