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