Trigger dbo.L_GLTax_DTrig

CREATE TRIGGER L_GLTax_DTrig ON L_GLTax FOR DELETE AS
/ *
* PREVENT DELETES IF DEPENDENT RECORDS IN ´D_GLJournal´
* /
IF (SELECT COUNT(*) FROM deleted, D_GLJournal WHERE (deleted.TaxCode = D_GLJournal.TaxCode)) > 0
BEGIN
RAISERROR(778427, 16, 1)
ROLLBACK TRANSACTION
END

Updated On: 05.04.01