|
Hi, I have a record that has been updated recently. Now I want to get a particular field that has been updated in record updation, How will I get the updated field with it's old value (field value before updating)? Thank you.
(comments are locked)
|
|
If the update transaction has already happened, then your only way of finding out the old value is to either inspect the transaction logs, or to restore a copy of the data before the modification. Going forward, you can access the values either by utilising the OUTPUT clause of the update statement, or by using DML triggers and referencing the
(comments are locked)
|
Your answer
