Enterprise ODBC Adapter :UPDATE Notification Trigger.

How can i get a field’s old value from Update Notification Trigger incase i modify the key field.

For eg, if i do an update on the table, like
Update

set key_field=value1 where key_field=value2.

When Update Trigger is triggered, i can get value1, but how can i get the old value2 from Trigger operation.

your suggestions are appreciated.

I have similar situation. did you find any solution yet? Appreciate your help.