Trigger dbo.L_GLSource_UTrig

CREATE TRIGGER L_GLSource_UTrig ON L_GLSource FOR UPDATE AS
/ *
* CASCADE UPDATES TO ´D_GLJournal´
* /
IF UPDATE(Module) OR UPDATE(Source)
BEGIN
UPDATE D_GLJournal
SET D_GLJournal.Module = inserted.Module , D_GLJournal.Source = inserted.Source
FROM D_GLJournal, deleted, inserted
WHERE deleted.Module = D_GLJournal.Module AND deleted.Source = D_GLJournal.Source
END

Updated On: 05.04.01