|Subject||Re: [firebird-support] Using variables in ESQL select statement|
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?