Trigger dbo.L_GLReportItem_ITrig

CREATE TRIGGER L_GLReportItem_ITrig ON L_GLReportItem FOR INSERT AS
/ *
* PREVENT INSERTS IF NO MATCHING KEY IN ´L_GLReport´
* /
IF (SELECT COUNT(*) FROM inserted) !=
(SELECT COUNT(*) FROM L_GLReport, inserted WHERE (L_GLReport.ReportID = inserted.ReportID))
BEGIN
RAISERROR(778423, 16, 1)
ROLLBACK TRANSACTION
END

Updated On: 05.04.01