Trigger

INC_BLSTATUS

Beschreibung

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

Definition

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

    UPDATE SRE_BLOCKS SET 
      BLSTATUS = :status 
    WHERE (BLID = NEW.HIBLID);
  END
END