ID: Q114503
The information in this article applies to:
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.
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.
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.
Additional reference words: FoxDos FoxWin 2.60 gpf errmsg err msg buglist2.60 KBCategory: kbprg kbtool kberrmsg kbbuglist KBSubcategory: FxtoolWizscreen
Last Reviewed: June 27, 1995