Trigger

INC_ITSTATUS

Beschreibung

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

Definition

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

    UPDATE SRE_ITEMTEMPLATES SET 
      ITSTATUS = :status 
    WHERE (ITID = NEW.BIITID);
  END
END