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?

Thanks
Anatoli Dounaevski

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