Trigger

STICHWORTINDEXE_DEL

Beschreibung

Löscht das Stichwort, wenn dieses nicht mehr in der StichwortIndexe Tabelle vorhanden ist.

Definition

CREATE TRIGGER STICHWORTINDEXE_DEL FOR STICHWORTINDEXE
ACTIVE AFTER DELETE POSITION 0
AS
  DECLARE VARIABLE status INTEGER;
BEGIN
  SELECT 
    COUNT(*) 
  FROM STICHWORTE SW, STICHWORTINDEXE SI
  WHERE (SW.SWID = OLD.SISWID) AND (SW.SWID = SI.SISWID)
  INTO
    :status;
   IF (status = 0) THEN
  BEGIN
    DELETE FROM STICHWORTE 
    WHERE (SWID = OLD.SISWID);
  END
END