HOWTO: Refreshing an Offline View in Visual FoxPro 5.0

The information in this article applies to:

• Microsoft Visual FoxPro for Windows, version 5.0

SUMMARY

If you want to refresh an offline view, the REQUERY() and REFRESH() functions do not work. You need to use the Dropoffline command and then create the offline view again.

MORE INFORMATION

The REQUERY() and REFRESH() functions, which are typically used to update a view, result in "Invalid operation for offline view." Also an offline view does not refresh when you issue the USE ONLINE command. The only way to refresh an offline view is to drop the view and re-create it. The code below gives you an example of how to refresh an offline view called MYVIEW that resides in MYOFFLINE DBC.

WARNING: All uncommitted changes made to the offline view will be lost.

CLOSE ALL SET MULTILOCKS ON OPEN DATABASE Myoffline =Dropoffline("Myview") =Createoffline("Myview") USE Myview BROWSE

This behavior is by design.

REFERENCE

For more information about creating offline views, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q155528
   TITLE     : How To Setup an Offline View in Visual FoxPro 5.0