Trigger dbo.L_GLDept_UTrig

CREATE TRIGGER L_GLDept_UTrig ON L_GLDept FOR UPDATE AS
/ *
* CASCADE UPDATES TO ´D_GLJournalItem´
* /
IF UPDATE(DeptCode)
BEGIN
UPDATE D_GLJournalItem
SET D_GLJournalItem.DeptCode = inserted.DeptCode
FROM D_GLJournalItem, deleted, inserted
WHERE deleted.DeptCode = D_GLJournalItem.DeptCode
END

/ *
* CASCADE UPDATES TO ´D_GLSum´
* /
IF UPDATE(DeptCode)
BEGIN
UPDATE D_GLSum
SET D_GLSum.DeptCode = inserted.DeptCode
FROM D_GLSum, deleted, inserted
WHERE deleted.DeptCode = D_GLSum.DeptCode
END

Updated On: 05.04.01