Trigger dbo.L_GLAccountOrg_UTrig

CREATE TRIGGER L_GLAccountOrg_UTrig ON L_GLAccountOrg FOR UPDATE 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 UPDATES IF NO MATCHING KEY IN ´L_GLAccount´
* /
IF UPDATE(ACCTCODE)
BEGIN
IF (SELECT COUNT(*) FROM inserted) !=
(SELECT COUNT(*) FROM L_GLAccount, inserted WHERE (L_GLAccount.AcctCode = inserted.ACCTCODE))
BEGIN
RAISERROR(778414, 16, 1)
ROLLBACK TRANSACTION
END
END

Updated On: 05.04.01