still working on triggers

[Greg25]

I am working with SQL 7

creating a trigger to activat, when the last_cost_center_ code on order_entry is updated. I would like to have the current date placed in status_date on Order_entry_1

when i ran the statment bleow it change the status_date for all the records except the one that was updated

Create Trigger status_date_change ON oder_entry
For Update As If Update Last_Cost_Center_Code
Begin
update order_entry_1 set Status_date = getdate()
from order_entry, inserted
where order_entry.job_number =
order_ entry_1.job_number

 

[tlbroadbent]

Create Trigger status_date_change ON oder_entry
For Update As

If Update Last_Cost_Center_Code
Begin
Update order_entry_1 Set Status_date = getdate()
From order_entry_1 Inner Join Inserted
On order_entry_1.job_number = inserted.job_number
Terry
------------------------------------
Blessed is the man who, having nothing to say, abstains from giving us worthy evidence of the fact. -George Eliot

 

[Greg25]

Thanks, Terry
I will try this later
Greg