At 03:04 PM 13/10/2004 +0000, you wrote:

>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!

Fields.OldValues['NameOfColumn'].AsString

Helen