Trigger

SENDEELEMENTE_INS

Beschreibung

Trigger um den TISTATUS anzupassen.

Definition

CREATE TRIGGER SENDEELEMENTE_INS FOR SENDEELEMENTE
ACTIVE AFTER INSERT POSITION 0
AS 
  DECLARE VARIABLE ActTiId     INTEGER;
  DECLARE VARIABLE ActTiStatus INTEGER;
  DECLARE VARIABLE hasUpdated  INTEGER;
  DECLARE VARIABLE ActTiTyp    VARCHAR(2);
BEGIN
  FOR SELECT TIID, TISTATUS, TITYP FROM TITEL
  WHERE (NEW.SETIID = TITEL.TIID)
  INTO :ActTiId, :ActTiStatus, :ActTiTyp
  DO BEGIN

    EXECUTE PROCEDURE TI_UPDATE_STATUS_WITH_RETURN ActTiId, ActTiStatus, ActTiTyp
      RETURNING_VALUES hasUpdated;

  END
END