>Kent ----
>
>Before doing an update, use the CURVAL() function to check if any of the fields have been updated at the server since the last refresh; i.e.:
>
>IF CURVAL("lastname") # table.lastname AND table.lastname = OLDVAL("lastname")
> WAIT WIND "Data has changed!!!"
>ENDIF
>
>
>
>>Is there a way to update the data buffered locally on your workstation. We can use Set Refresh to 5,1 but
>>find that this can slow down the network. (buffer updated every second.) Also there is still a one second window were another workstation could get the wrong data. Native tables can’t use Refresh(). Local views could be used accompanied by Refresh() but not a option right now.
>>
>>Problem : application uses native tables. User updates data, changes are not seen on other workstations until the time in set refresh has expired.
>>
>>BufferMode -Optimistic
>>DataSession - Private Datasession
>>
>>Thanks.


The problem that I am having is that user A updates a record. Changes city value from "Toronto" to "Chicago". User B updates the record and still sees "Toronto". If user B updates the record after the set refresh values have expired he will see "Chicago". Is there another way to update the buffer other than using set refresh?