How To Refresh an Offline View in Visual FoxPro (155820)


The information in this article applies to:

  • Microsoft Visual FoxPro for Windows 5.0
  • Microsoft Visual FoxPro for Windows 6.0
This article was previously published under Q155820

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

STATUS

This behavior is by design.

REFERENCES

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

155528 How To Setup an Offline View in Visual FoxPro 5.0

Modification Type:MinorLast Reviewed:7/1/2004
Keywords:kbhowto KB155820
©2004 Microsoft Corporation. All rights reserved.