Beschreibung
Delete-Trigger für die Replikation
Definition
CREATE TRIGGER TITELTRAEGER_AFTER_DEL FOR TITELTRAEGER
INACTIVE AFTER DELETE POSITION 0
AS
BEGIN
IF (USER <> 'REPLICATION') THEN BEGIN
INSERT INTO REPLICATION (TID, TID2, TABLENAME, MODUS, RTID, IDNAME, ID2NAME, REPTIME)
VALUES (OLD.TTTRID, OLD.TTTIID, 'TITELTRAEGER', 3, 17, 'TTTRID', 'TTTIID', 'NOW');
END
END
![]() ![]() ![]() |