Trigger Previous topic Chapter index Next topic

SRE_DAYITEMS_AFTER_DEL

 

Beschreibung

Delete-Trigger für die Replikation

 

Definition

CREATE TRIGGER SRE_DAYITEMS_AFTER_DEL FOR SRE_DAYITEMS
INACTIVE AFTER DELETE POSITION 0
as
begin 
  if (USER <> 'REPLICATION') then 
  begin
    insert into replication (tid,      tablename,      modus, rtid, idname, reptime) 
    values                  (old.diid, 'SRE_DAYITEMS', 3,     55,   'DIID', 'now');
  end
end

 

     Previous topic Chapter index Next topic