Trigger

DEC_DASTATUS

Beschreibung

Setzt den Tag Status beim Senderaster Editor um eins zurück.

Definition

CREATE TRIGGER DEC_DASTATUS FOR SRE_WAVEITEMS
ACTIVE AFTER DELETE POSITION 0
AS
  DECLARE VARIABLE status INTEGER;
BEGIN
  IF (OLD.WIDAID IS NOT NULL) THEN BEGIN
    SELECT COUNT(*) FROM SRE_WAVEITEMS 
    WHERE (WIDAID = OLD.WIDAID)
    INTO :status;

    UPDATE SRE_DAYS SET 
      DASTATUS = :status 
    WHERE (DAID = OLD.WIDAID);
  END
END