Subject Could the field value be retrieved in a trigger by the field name as a string?
Author Anatoli M. Dounaevski
Hi everybody,

I want to build the "first" part of the update query, which relate to the last table modification, in the before/after update trigger for that table. "First" part starts with "update" and includes everything before "where". I can make a loop over all fields in the specified table using the system tables, in the loop I need to retrieve the field values (old, new) using the field name as varchar, and compare them. This is a problem. Is there a way to get field value in a trigger when knowing the field name as a string?

Anatoli Dounaevski

[Non-text portions of this message have been removed]