>>>>>>I have coded an EXE in vfp50. This application installs on the user's computer and the data lives on a network server. When one user updates the record, and another user is viewing the same record, her record should automatically update or so I thought. You can see the updated record if you exit the program and restart it. Can someone tell me what is wrong.
>>>>>
>>>>>the second user will not see the update until she refreshes her data set.
>>>>Hi Dave: in the help, it says...
>>>>SET REFRESH can also be used to specify how often data buffered locally on your workstation is updated.... In my main.prg, I have SET REFRESH to 5,10...
>>>>I know SET REFRESH works on a BROWSE, but shouldn't this work on my work station too?
>>>
>>>
>>>Because in a BROWSE, you are directly editing the data. On a form, the data is generally buffered in someway.
>>---
>>Is there a way to refresh buffered data on a work station in vfp50 without
>>having to exit and restart to program or retrieve the data again? :)
>
>
>Not without retrieving the data again. How do you get the updated data without retrieving it?
---
by having a TSR in vfp that checks for changes in the tables and updates
the work stations from time to time. you could set up the update intervals
with some kind of SET command. :)