Trigger

SRE_BLOCKS_AFTER_UP

Beschreibung

Update-Trigger für die Replikation

Definition

CREATE TRIGGER SRE_BLOCKS_AFTER_UP FOR SRE_BLOCKS
INACTIVE AFTER UPDATE POSITION 0
as
begin 
  if ((USER <> 'REPLICATION') and (old.blstatus = new.blstatus)) then 
  begin
    insert into replication (tid,      tablename,    modus, rtid, idname, reptime) 
    values                  (new.blid, 'SRE_BLOCKS', 2,     52,   'BLID', 'now');
  end
end