Trigger dbo.D_GLJournal_ITrig

CREATE TRIGGER D_GLJournal_ITrig ON D_GLJournal 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 TaxCode IS NULL) > 0
BEGIN
RAISERROR 44444 ´Field ´´TaxCode´´ 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 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
IF (SELECT COUNT(*) FROM inserted) !=
(SELECT COUNT(*) FROM L_GLSource, inserted WHERE (L_GLSource.Module = inserted.Module AND L_GLSource.Source = inserted.Source))
BEGIN
RAISERROR(778426, 16, 1)
ROLLBACK TRANSACTION
END
IF (SELECT COUNT(*) FROM inserted) !=
(SELECT COUNT(*) FROM L_GLTax, inserted WHERE (L_GLTax.TaxCode = inserted.TaxCode))
BEGIN
RAISERROR(778429, 16, 1)
ROLLBACK TRANSACTION
END
IF (SELECT COUNT(*) FROM inserted) !=
(SELECT COUNT(*) FROM D_Period, inserted WHERE (D_Period.DocPeriod = inserted.DocPeriod))
BEGIN
RAISERROR(778432, 16, 1)
ROLLBACK TRANSACTION
END

Updated On: 05.04.01