At 07:01 PM 7/11/2003 +1100, you wrote:

> > There is no way to create run-time references to metadata objects
> > in PSQL.
> > If you want to perform this test in a trigger, you will have to hard-code
> > it for each column in your PSQL code. You could, however, create a
> > client-side utility routine for yourself, to build a script for creating
> > such BEFORE UPDATE triggers for each of your volatile tables.
> > Your program
> > can query RDB$RELATION_FIELDS to get all of the column names for a table.
> >
> > heLen
>
>Helen,
>Doesn't IBO do some of this magic for you anyway by only updating changed
>fields?

Updates can be done that way. And IBO can certainly tell you which columns
have been modified by an edit operation. It keeps lists of OLD and NEW
values, right up until the commit. But Jonathan was asking for that
capability on the server side, *after* stuff has been posted to the server.

H.