Well, I'm not Jeff, but since I've given you a wrong answer to your original question I'm replying to this one also...

I wasn't aware of this option in triggers. After reading your quote I've checked it out and it does work as described! I've checked it on 8.1.5 (the only one that I have handy at this moment), it works. What surprised me in the sintax is that you actualy have to put column names in single quotes. And even though you are passing column names as litterals, they are case insensitive... I don't know why it doesn't work for you, check your trigger syntax once more.

But there is one fundamental difference between this kind of determining if column is being updated and the one you used in your original question (the one with IF :new.col1 <> :0ld.col1 OR .... ENDIF). The one with "IF .. <> .. END IF" will fire only if column value is realy changed by the update, while the one with "IF UPDATING (col1).." will fire even if your update does not realy change the existing value in col1 (i.e. when you overwrite the value in col1 with the same value it allready have).

HTH,

[Edited by jmodic on 03-23-2001 at 05:04 PM]