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

If you read the documentation or the source code you will find more than
one possibility do get the old value:
You can use directly a TIB_Column too.

query.FieldByName('NameOfColumn').OldAsString;

No work with variants.

Andreas Hesse


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