Trigger Previous topic Chapter index Next topic

SI_AFTER_INS_UP_TISTATUS

 

Beschreibung

Trigger um den TISTATUS anzupassen.

 

Definition

CREATE TRIGGER SI_AFTER_INS_UP_TISTATUS FOR SENDUNGITEMS
ACTIVE AFTER INSERT POSITION 1
AS
begin
  if (new.smtiid is not null) then
  begin
    execute procedure TI_UPDATE_STATUS(new.smtiid, 32767);
  end
end

 

     Previous topic Chapter index Next topic