Is there a way, in a Before update trigger, to know the name of the
column updated?

eg: I have a table with 6 columns , and a Before update trigger on this
table in order to add the Today date in the column 6.
But I don't want the trigger add a date to the column 6 if the column 2
is updated. Is it possible?

I know I can work with old.column2, new. column2 but
I did a test in order to update a row in column 2. Initiale value was 0
new value was 5 . In this case I can used something like old.column2<>
new. column2
But if update column1, and column2 has an Initiale value to 0,
old.column2 = new.column2 is true ??? old.column2 =0 and new.column2=0

Yves Cravic
Antenna
tél 02 51 66 84 37
fax 02 51 66 89 09
E MAIL ycravic@...



[Non-text portions of this message have been removed]