Subject Accessing 'previous' values during posting/commiting
Author bamber12001
Hi all,

I have a database which stores budget and forecast figures. I want
to keep track of any changes to these figures in a text file. This
text file should store the before and after values, everytime a
record is changed.

I know I can access the previous values using OLD and NEW in my SQL
query (in the UpdateSQL section), but is there anything like this
available on the Delphi side of things?

I tried using the Buffer information, but this only seemed to have
the new value's.

I can obviously take a copy of the values before they are editted,
but I would prefer to do it a 'clever' way!