Microsoft KB Archive/114639

{| = BUG: FoxPro Crashes When Overwriting an Existing File =
 * width="100%"|

ID: Q114639

2.60 WINDOWS

buglist2.60 The information in this article applies to:
 * Microsoft FoxPro for Windows, version 2.6

SYMPTOMS
When FoxPro is attempting to overwrite an existing .DBF file after an import, one of the following situations occurs:

 FoxPro returns a FoxPro Application Error or an "Unrecognized command..." error with Cancel, Suspend, and Ignore options. -or- FoxPro enters an endless loop in which it cycles through the source and target dialog boxes until you choose Cancel. -or- FoxPro produces a general protection (GP) fault.

CAUSE
The cause of this problem has not yet been determined.

RESOLUTION
To avoid this problem, check for the existence of the file before sending output to it. If the file exists, delete it.

STATUS
Microsoft has confirmed this to be a problem FoxPro 2.6 for Windows. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Steps to Reproduce Problem
1. Start Catalog Manager.

2. Create a new, empty catalog.

3. From the Data menu, choose Import.

4. Import a Microsoft Excel 4.0 worksheet named TEST.XLS into the default

directory. 5. From the Data menu, choose Export, and change the type to Multiplan 4.01. 6. Set the save as directory to be the same as the default directory. 7. From the Data menu, choose Import, and change the type to Multiplan

4.01. 8. When you are asked "Overwrite dbf?", choose Yes. 9. In the Import Data dialog box, choose OK.

At this point one of the problems described above will occur.

You can also reproduce the problem by running the following code:

IMPORT FROM :\excel\qe\ .xls TYPE xls COPY TO .mod TYPE mod USE IMPORT FROM .mod TYPE mod For example: IMPORT FROM d:\excel\qe\emp.xls TYPE xls COPY TO emp.mod TYPE mod USE IMPORT FROM emp.mod TYPE mod Additional reference words: FoxWin 2.60 buglist2.60 spreadsheet target source KBCategory: KBSubcategory: FxtoolCatman Keywords         : kberrmsg FxtoolCatman Version          : 2.60 Platform         : WINDOWS
 * }