Re: [firebird-support] Using variables in ESQL select statement

[John Bishop john_b_bis...@yahoo.com [firebird-support]]

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?
Thanks