>
>Thanks for the UPDATE(column) function which I didn't know. But the question still remains - is it OK or not to UPDATE another column in the UPDATE trigger.
>
I do that in a lot of triggers - I fill in the SQL username/update datetime/ and other fields that can be automated.
OTOH I am the DBA for the majority of systems I work on so I can ensure recursive triggers is off.
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________