Hi Yves,

Yves Glodt wrote:

>I wonder if I fire a trigger on update, is there a possibility of
>knowing which fields have changed, or do I have to do that "manually" by
>comparing .old and .new ?
>
>

the manual way:

IF (new.birthday = old.birthday) THEN BEGIN
new.birthdaychangedflag = 'F';
END ELSE BEGIN
new.birthdaychangedflag = 'T';
END

I'm not aware of an existing list, which has all the changed items
inside. And I guess, you have to react on the changed items individually.

Best regards

Christian