Trigger

SRE_BLOCKITEMS_AFTER_UP

Beschreibung

Update-Trigger für die Replikation

Definition

CREATE TRIGGER SRE_BLOCKITEMS_AFTER_UP FOR SRE_BLOCKITEMS
INACTIVE AFTER UPDATE POSITION 0
as
begin 
  if (USER <> 'REPLICATION') then 
  begin
    insert into replication (tid,      tablename,        modus, rtid, idname, reptime) 
    values                  (new.biid, 'SRE_BLOCKITEMS', 2,     51,   'BIID', 'now');
  end
end