Trigger

INC_DASTATUS

Beschreibung

Erhöht den DAYS Status beim Senderaster Editor um eins.

Definition

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

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