How to Clean Up the Visual FoxPro Environment

 Last reviewed: October 18, 1996
Article ID: Q129711
The information in this article applies to:
  • Microsoft Visual FoxPro for Windows, versions 3.0, 5.0

SUMMARY

This article discusses a recommended series of commands to clean up the Visual FoxPro Environment at these times: 

  - When closing down the application.
  - During Transactions.
  - During Buffered Updates.

MORE INFORMATION

A Visual FoxPro application needs to accomplish the following items in order to guarantee a clean Visual FoxPro environment: 

  - Clean Up During Transactions.
  - Clean Up During Buffered Updates.
  - Return Visual FoxPro to its state at startup.
The major tasks that should be accomplished during the cleanup process are: 

  - Close down all operations.
  - Remove all objects from memory.
  - Close all private data sessions and cursors.
  - Clear the compiled program buffer.
  - Make sure Visual FoxPro reads programs from disk, not buffer.
Details on how to accomplish these steps are outlined below.

How to Close Down All Operations and Return FoxPro to Its State at Startup

To close down all operations and return Visual FoxPro to its state at startup, issue the following commands, in order, in the Command window: 

  CLEAR ALL
  CLOSE ALL
  CLEAR PROGRAM
The CLEAR ALL command removes all objects from memory which, in turn, dlose all private data sessions and cursors. The the CLOSE ALL command closes all databases, tables, and cursors in data session 1, which is the default Visual FoxPro data session. Then the CLEAR PROGRAM command clears the compiled program buffer of the most recently executed programs, and it forces Visual FoxPro to read the programs from disk, rather than from the program buffer.

Special Consideration: Cleaning Up During Transactions

If transactions are in progress, use the END TRANSACTION command for each level of transaction before issuing the the CLEAR ALL, CLOSE ALL, and CLEAR PROGRAM commands.

Special Consideration: Cleaning Up During Buffered Updates

If buffered updates are in progress, use either the TABLEUPDATE() or TABLEREVERT() functions for each cursor with buffered updates before issuing the CLEAR ALL, CLOSE ALL, and CLEAR PROGRAM commands.

Additional reference words: 5.00 VFoxWin 3.00 Cleanup Code
KBCategory: kbenv kbhowto
KBSubcategory: FxenvOptimize

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: October 18, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.