Trigger

SI_AFTER_UP_UP_TISTATUS

Beschreibung

Trigger um den TISTATUS anzupassen.

Definition

CREATE TRIGGER SI_AFTER_UP_UP_TISTATUS FOR SENDUNGITEMS
ACTIVE AFTER UPDATE POSITION 1
AS
begin
  if (old.smtiid is not null) then
  begin
    execute procedure TI_UPDATE_STATUS(old.smtiid, 32767);
  end
  if ((new.smtiid is not null) and 
      ((new.smtiid <> old.smtiid) or (old.smtiid is null))) then
  begin
    execute procedure TI_UPDATE_STATUS(new.smtiid, 32767);
  end
end