Trigger Previous topic Chapter index Next topic

SRE_ITEMTEMPLATES_AFTER_INS

 

Beschreibung

Insert-Trigger für die Replikation

 

Definition

CREATE TRIGGER SRE_ITEMTEMPLATES_AFTER_INS FOR SRE_ITEMTEMPLATES
INACTIVE AFTER INSERT POSITION 0
as
begin 
  if (USER <> 'REPLICATION') then 
  begin
    insert into replication (tid,      tablename,           modus, rtid, idname, reptime) 
    values                  (new.itid, 'SRE_ITEMTEMPLATES', 1,     50,   'ITID', 'now');
  end
end

 

     Previous topic Chapter index Next topic