>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?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only