Trigger Previous topic Chapter index Next topic

WOCHENTAG_AFTER_UP

 

Beschreibung

Update-Trigger für die Replikation

 

Definition

CREATE TRIGGER WOCHENTAG_AFTER_UP FOR WOCHENTAG
INACTIVE AFTER UPDATE POSITION 0
as
begin 
  if (USER <> 'REPLICATION') then 
  begin
    insert into replication (tid,      tablename,   modus, rtid, idname, reptime) 
    values                  (new.wtid, 'WOCHENTAG', 2,     49,   'WTID', 'now');
  end
end

 

     Previous topic Chapter index Next topic