BUG: Screen Wizard Does Not Release Memory Handles

ID: Q114503

The information in this article applies to:

• Microsoft FoxPro for Windows, version 2.6
• Microsoft FoxPro for MS-DOS, version 2.6

SYMPTOMS

Memory handles appear to be used but not released from within FoxPro for Windows and FoxPro for MS-DOS when the following two conditions are met:

1. A relational updatable query is created from within the Query Wizard and

   is made active.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Steps to Reproduce Problem

CAUTION: The following procedure can result in an "Insufficient Memory" error message after the steps have been executed numerous times (approximately 10). This procedure should not be performed without closing all other applications running under Windows first. This is a precaution, as a general protection (GP) fault will also occur eventually. Should a GP fault occur, quit and restart Windows before starting FoxPro again.

1. Create a program containing the following line and add the program to

   your catalog:

      WAIT WINDOW SYS(1011)

   This command will display how many memory handles you have used.

   three or four tables. For example, link INVOICES to CUSTOMER and DETAIL
   (these tables are in the sample catalog). Make the new query active by
   choosing the Use push button while the query is selected (highlighted).

4. With that query still active, start the Screen Wizard.

5. Choose Cancel in the first screen of the wizard.

6. Check your memory handles again by running the program.

Note that the number of memory handles used has increased markedly. Continued repetition of the above steps will cause more and more memory handles to be used and will eventually result in an "Insufficient Memory" error message and then a GP fault.