Trigger dbo.D_Period_DTrig

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

/ *
* PREVENT DELETES IF DEPENDENT RECORDS IN ´D_GLJournalItem´
* /
IF (SELECT COUNT(*) FROM deleted, D_GLJournalItem WHERE (deleted.DocPeriod = D_GLJournalItem.AllocPeriod)) > 0
BEGIN
RAISERROR(778433, 16, 1)
ROLLBACK TRANSACTION
END

/ *
* PREVENT DELETES IF DEPENDENT RECORDS IN ´D_GLSum´
* /
IF (SELECT COUNT(*) FROM deleted, D_GLSum WHERE (deleted.DocPeriod = D_GLSum.DocPeriod)) > 0
BEGIN
RAISERROR(778436, 16, 1)
ROLLBACK TRANSACTION
END

Updated On: 05.04.01