> -----Original Message-----
> 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 ?

AFAIK you have to use old and new, however if your doing this on a large
scale you might want to look at using LogManager from upscene.

hih

Si Carter
http://www.fbtalk.net/ - Web Based Firebird Forum
http://sourceforge.net/projects/fbutils - FBUtils
http://www.tectsoft.net/ - Homepage