Subject Re: [firebird-support] Using variables in ESQL select statement
Author John Bishop
I had a look at IB LogManager. It doesn't quite do what I want.

The requirement we have is to log only fields that change, not all fields (which is what IB LogManager does). If I change fields 1, 4, and 7 then those are the only fields I want logged (and not fields 1, 2, 3, 4, 5, 6, and 7).

We also use Postgres and have found a way to do this.

The issues we are facing in Firebird appear to be a) the new. and old. parameters appear to be only available in a trigger - they are not made available to procedures, external programs, etc. and b) we can not put the field name into a variable and then in the trigger concatenate new.(variable) into a field name to be called.

If either of these were available then we could do what is required very simply. I don't know how IB LogManager does it, and would be interested in understanding so we could put it all inside the database.

Any other suggestions out there?