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.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05