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.