About Eldus » Software » Trigger dbo.L_GLJob_UTrig

Trigger dbo.L_GLJob_UTrig

CREATE TRIGGER L_GLJob_UTrig ON L_GLJob FOR UPDATE AS

/ *
* PREVENT NULL VALUES IN ´DeptCode´
* /
IF (SELECT Count(*) FROM inserted WHERE DeptCode IS NULL) > 0
BEGIN
RAISERROR 44444 ´Field ´´DeptCode´´ cannot contain a null value.´
ROLLBACK TRANSACTION
END
/ *
* CASCADE UPDATES TO ´D_GLJournalItem´
* /
IF UPDATE(JobCode)
BEGIN
UPDATE D_GLJournalItem
SET D_GLJournalItem.JobCode = inserted.JobCode
FROM D_GLJournalItem, deleted, inserted
WHERE deleted.JobCode = D_GLJournalItem.JobCode
END

Updated On: 05.04.01