Trigger dbo.L_GLAccountOrg_ITrig

CREATE TRIGGER L_GLAccountOrg_ITrig ON L_GLAccountOrg FOR INSERT AS

/ *
* PREVENT NULL VALUES IN ´LocationCode´
* /
IF (SELECT Count(*) FROM inserted WHERE LocationCode IS NULL) > 0
BEGIN
RAISERROR 44444 ´Field ´´LocationCode´´ cannot contain a null value.´
ROLLBACK TRANSACTION
END
/ *
* PREVENT INSERTS IF NO MATCHING KEY IN ´L_GLAccount´
* /
IF (SELECT COUNT(*) FROM inserted) !=
(SELECT COUNT(*) FROM L_GLAccount, inserted WHERE (L_GLAccount.AcctCode = inserted.ACCTCODE))
BEGIN
RAISERROR(778415, 16, 1)
ROLLBACK TRANSACTION
END

Updated On: 05.04.01