Trigger dbo.L_GLReportItem_UTrig

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

Updated On: 05.04.01