Trigger Previous topic Chapter index Next topic

EINSAETZE_AFTER_UP

 

Beschreibung

Update-Trigger für die Replikation

 

Definition

CREATE TRIGGER EINSAETZE_AFTER_UP FOR EINSAETZE
INACTIVE AFTER UPDATE POSITION 0
as
begin if (USER <> 'REPLICATION') then begin
insert into replication (tid,tablename,modus,rtid,idname,reptime) values (new.eiid,'EINSAETZE',2,25,'EIID','now');
end
end

 

     Previous topic Chapter index Next topic