At 12:40 PM 07-08-01 +0100, you wrote:

>Help Please.
>
>I have a temporary table with only one record. This is presented to users on
>a form via a tib_query connected to various tib_controls.
>I want to know when and if the user modifies the record.
>I thought I could use the 'Modified' property of a dataset to test this. But
>when I check it is always true.
>
>(after opening the query the dataset is modified by the program by setting
>one of the field values. So how can I clear this Modified flag)
>
>Or is there another way or an event which will tell me when a dataset is
>altered ?

Consider the IsModified property of the TIB_Column or the GetColumnValue('columnname') and GetColumnOldValue('columnname') properties of TIB_Row.

-- helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________