Robert martin wrote:

> Sometimes however we recalculate values in records based on changes in
> other tables. When we do this the values do not often change but our
> trigger counts that as a change and 'marks' the record as updated. To
> avoid this we could change our trigger to compare the Old and New field
> values. This however has a large ongoing maintenance cost

You should automate it. Either look at the product Thomas has mentioned
(if it fits your needs) or build your own. It's shouldn't be too
complex, just read the info from system tables and write the code that
will create ALERT TRIGGER statements where you need them.



--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================