Trigger dbo.L_GLSource_DTrig

CREATE TRIGGER L_GLSource_DTrig ON L_GLSource FOR DELETE AS
/ *
* PREVENT DELETES IF DEPENDENT RECORDS IN ´D_GLJournal´
* /
IF (SELECT COUNT(*) FROM deleted, D_GLJournal WHERE (deleted.Module = D_GLJournal.Module AND deleted.Source = D_GLJournal.Source)) > 0
BEGIN
RAISERROR(778424, 16, 1)
ROLLBACK TRANSACTION
END

Updated On: 05.04.01