Trigger dbo.D_GLBudgetItem_ITrig

CREATE TRIGGER D_GLBudgetItem_ITrig ON D_GLBudgetItem FOR INSERT AS
IF (SELECT Count(*) FROM inserted WHERE AcctCode IS NULL) > 0
BEGIN
RAISERROR 44444 ´Field ´´AcctCode´´ cannot contain a null value.´
ROLLBACK TRANSACTION
END
ELSE
IF (SELECT Count(*) FROM inserted WHERE DeptCode IS NULL) > 0
BEGIN
RAISERROR 44444 ´Field ´´DeptCode´´ cannot contain a null value.´
ROLLBACK TRANSACTION
END
ELSE
IF (SELECT Count(*) FROM inserted WHERE JobCode IS NULL) > 0
BEGIN
RAISERROR 44444 ´Field ´´JobCode´´ cannot contain a null value.´
ROLLBACK TRANSACTION
END
ELSE
IF (SELECT Count(*) FROM inserted WHERE CurrencyCode IS NULL) > 0
BEGIN
RAISERROR 44444 ´Field ´´CurrencyCode´´ cannot contain a null value.´
ROLLBACK TRANSACTION
END
ELSE
IF (SELECT Count(*) FROM inserted WHERE Debit IS NULL) > 0
BEGIN
RAISERROR 44444 ´Field ´´Debit´´ cannot contain a null value.´
ROLLBACK TRANSACTION
END
ELSE
IF (SELECT Count(*) FROM inserted WHERE Credit IS NULL) > 0
BEGIN
RAISERROR 44444 ´Field ´´Credit´´ cannot contain a null value.´
ROLLBACK TRANSACTION
END
ELSE
IF (SELECT Count(*) FROM inserted WHERE Description IS NULL) > 0
BEGIN
RAISERROR 44444 ´Field ´´Description´´ cannot contain a null value.´
ROLLBACK TRANSACTION
END
ELSE
IF (SELECT Count(*) FROM inserted WHERE CurrencyRate IS NULL) > 0
BEGIN
RAISERROR 44444 ´Field ´´CurrencyRate´´ cannot contain a null value.´
ROLLBACK TRANSACTION
END
ELSE
IF (SELECT Count(*) FROM inserted WHERE CurrencyDebit IS NULL) > 0
BEGIN
RAISERROR 44444 ´Field ´´CurrencyDebit´´ cannot contain a null value.´
ROLLBACK TRANSACTION
END
ELSE
IF (SELECT Count(*) FROM inserted WHERE CurrencyCredit IS NULL) > 0
BEGIN
RAISERROR 44444 ´Field ´´CurrencyCredit´´ cannot contain a null value.´
ROLLBACK TRANSACTION
END
ELSE
IF (SELECT Count(*) FROM inserted WHERE AllocPeriod IS NULL) > 0
BEGIN
RAISERROR 44444 ´Field ´´AllocPeriod´´ cannot contain a null value.´
ROLLBACK TRANSACTION
END

Updated On: 05.04.01