Edcal.com On Accounting

Home » Software » 

Trigger dbo.L_GLTax_UTrig

CREATE TRIGGER L_GLTax_UTrig ON L_GLTax FOR UPDATE AS
/ *
* CASCADE UPDATES TO ´D_GLJournal´
* /
IF UPDATE(TaxCode)
BEGIN
UPDATE D_GLJournal
SET D_GLJournal.TaxCode = inserted.TaxCode
FROM D_GLJournal, deleted, inserted
WHERE deleted.TaxCode = D_GLJournal.TaxCode
END


Mail this pageMail this page