SIMPLE TRIGGER QUESTION

[SeanB]

Hello what is the syntax for a trigger just to have it on specific fields being updated. For example, I have a table called tblOrders. If field called "Driver" is updated I want the trigger to fire. Thanks. I dont want to trigger to fire on the whole table.

 

[fousek]

SeanB -

You can't have a trigger fire on individual fields, but inside the trigger you can use an "if update", like so:

if update(Driver)
Begin
do some processing
end

APF