About Eldus » Software » Trigger dbo.D_GLBudget_ITrig

Trigger dbo.D_GLBudget_ITrig

CREATE TRIGGER D_GLBudget_ITrig ON D_GLBudget FOR INSERT AS
IF (SELECT Count(*) FROM inserted WHERE DocPeriod IS NULL) > 0
BEGIN
RAISERROR 44444 ´Field ´´DocPeriod´´ cannot contain a null value.´
ROLLBACK TRANSACTION
END
ELSE
IF (SELECT Count(*) FROM inserted WHERE Module IS NULL) > 0
BEGIN
RAISERROR 44444 ´Field ´´Module´´ cannot contain a null value.´
ROLLBACK TRANSACTION
END
ELSE
IF (SELECT Count(*) FROM inserted WHERE Source IS NULL) > 0
BEGIN
RAISERROR 44444 ´Field ´´Source´´ cannot contain a null value.´
ROLLBACK TRANSACTION
END
ELSE
IF (SELECT Count(*) FROM inserted WHERE TransDate IS NULL) > 0
BEGIN
RAISERROR 44444 ´Field ´´TransDate´´ cannot contain a null value.´
ROLLBACK TRANSACTION
END
ELSE
IF (SELECT Count(*) FROM inserted WHERE TaxCode IS NULL) > 0
BEGIN
RAISERROR 44444 ´Field ´´TaxCode´´ 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

Updated On: 05.03.31