>>>>>In have an app in vfp60 that works on the network. I need to refresh data
>>>>>from time to time so the user can see uptodate information. What is the call
>>>>>to REFRESH DATA?
>>>>
>>>>=refresh()
>>>Hi James,
>>>Having problems...=refresh() is not working. I am getting an error message
>>>saying "No update tables are specified. Use the Table property of the Cursor."
>>
>>Are you using an updateable view? If not, you will need to requery the view:
>>=requery()
>>
>>There are differences between the two functions, which are explained in the help. Basically, the requery() returns all the data for a view, and the refresh() reexecutes the query on which the view is based. With the refresh() function, you have the option of refreshing the data for particular set of rows. Generally, requery() is a lot faster.
>----
>I am just using vfp tables. On one computer, I have the program up and running and I will make a change to the fld value. I would like to see this change show up on another computer that also has the program up and running and.
Short answer. It ain't easy. If what you want to do is have some data on a form on one workstation, change the data on another workstation, and have that form on the first workstation show the new data, then you have to refresh the first form (YourForm.Refresh()). You may be able to do this with a timer, but even that gets in the way if you're actively using the form. Like I said, it ain't easy! < s >