Trigger

PRODUKTE_INS

Beschreibung

Trigger um den Primary Key zu setzen.

Definition

CREATE TRIGGER PRODUKTE_INS FOR PRODUKTE
ACTIVE BEFORE INSERT POSITION 0
AS 
BEGIN 
  IF (NEW.PRID IS NULL) THEN 
     NEW.PRID = GEN_ID(PRID_GEN, 2);
END