Trigger

NEWSSENDUNGEN_UPD_STATUS

Beschreibung

Trigger um den Status bei allen Verknüpften Elementen zu setzen.

Definition

CREATE TRIGGER NEWSSENDUNGEN_UPD_STATUS FOR NEWSSENDUNGEN
ACTIVE AFTER UPDATE POSITION 1
AS
BEGIN
  IF (OLD.NESTATUS <> NEW.NESTATUS) THEN BEGIN
  
    UPDATE NEWSSENDUNGEN SET NESTATUS = NEW.NESTATUS
    WHERE (NEW.NEID = NEAUSGABEID) AND (NEW.NEID <> NEID);

  END
END