About Eldus » Software » Trigger dbo.L_Currency_DTrig

Trigger dbo.L_Currency_DTrig

CREATE TRIGGER L_Currency_DTrig ON L_Currency FOR DELETE AS
/ *
* PREVENT DELETES IF DEPENDENT RECORDS IN ´D_GLJournalItem´
* /
IF (SELECT COUNT(*) FROM deleted, D_GLJournalItem WHERE (deleted.CurrencyCode = D_GLJournalItem.CurrencyCode)) > 0
BEGIN
RAISERROR(778408, 16, 1)
ROLLBACK TRANSACTION
END

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

Updated On: 05.04.01