Trigger dbo.L_Currency_ITrig

CREATE TRIGGER L_Currency_ITrig ON L_Currency FOR INSERT AS

/ *
* VALIDATION RULE FOR FIELD ´CurrencyRate´
* /
IF (SELECT Count(*) FROM inserted WHERE NOT (CurrencyRate<>0)) > 0
BEGIN
RAISERROR(778403, 16, 1)
ROLLBACK TRANSACTION
END

Updated On: 05.04.01