Trigger

DEC_HRSTATUS

Beschreibung

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

Definition

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

    UPDATE SRE_HOURS SET 
      HRSTATUS = :status 
    WHERE (HRID = OLD.DIHRID);
  END
END