Hi,

I have three tables :

StatusTable --> has columns empid, haschanged

EmpTable --> has columns empid, empname, descr

SalaryTable --> has columns empid, salary

I want to create a trigger that updates the column 'haschanged' in the Status table only if the values of 'empname', 'descr' or 'salary' change after an update.

what's the best way to do this? thanks!

Well, just create an AFTER UPDATE trigger. What exactly is the problem there?

So far I have this and it works -->

CREATE TRIGGER EmpUpdate_tgr
AFTER UPDATE OF empname, descr ON EmpTable
REFERENCING NEW AS N OLD AS O
FOR EACH ROW
WHEN( (N.empname != O.empname) OR (N.descr != O.descr) )
UPDATE StatusTable SET haschanged = 't' WHERE empid = N.empid;

But how can I include the Salary table as a part of this trigger? Is it possible to do that?

No, you'll need two triggers, one on each table.
Updating the "haschanged" flag twice shouldn't be problematic, I suppose.

No, changing the 'haschanged' flag twice isn't a problem at all... how about nested triggers? What are they used for...could they be used in this case? Thanks!

In this case you want to trigger two different actions, viz. updates in EmpTable and updates in SalaryTable. For that purpose you'll need at least two triggers.
Since two fairly simple triggers will do the job, I don't see any need for more complex triggers.

thank you.. i created two triggers and it works just fine..