Beschreibung
Delete-Trigger für die Replikation
Definition
CREATE TRIGGER UHRENRASTER_AFTER_DEL FOR UHRENRASTER
INACTIVE AFTER DELETE POSITION 0
AS
BEGIN
IF (USER <> 'REPLICATION') THEN BEGIN
INSERT INTO REPLICATION (TIDCHAR, TID2CHAR, TABLENAME, MODUS, RTID, IDNAME, ID2NAME, REPTIME)
VALUES (OLD.URNAME, OLD.URSTUNDE, 'UHRENRASTER', 3, 68, 'URNAME', 'URSTUNDE', 'NOW');
END
END
![]() ![]() ![]() |