Beschreibung
Delete-Trigger für die Replikation
Definition
CREATE TRIGGER TITEL_MERKMAL_ATTR_AFTER_DEL FOR TITEL_MERKMAL_ATTRIBUT
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.TMMAID, OLD.TMTIID, 'TITEL_MERKMAL_ATTRIBUT', 3, 62, 'TMMAID', 'TMTIID', 'NOW');
END
END
![]() ![]() ![]() |