Microsoft KB Archive/156581

= PRB: INSERT Can Freeze VFP if Table's Index File Corrupted =

Article ID: 156581

Article Last Modified on 10/15/2003

-

APPLIES TO


 * Microsoft Visual FoxPro 5.0 Standard Edition
 * Microsoft Visual FoxPro 6.0 Professional Edition

-



This article was previously published under Q156581



SYMPTOMS
If the INSERT command is executed on a Table that has a corrupted Index file, Visual FoxPro can freeze with the following error:

"This program has caused an illegal operation and will be shutdown"



RESOLUTION
To fix this problem, do one of the following:

 Issue the REINDEX command to attempt to repair the index file.  Copy the structure and contents of the table in question to another table as follows: USE TstTable COPY STRUCTURE TO mytst WITH PRODUCTION USE mytst IN 0 SELECT mytst APPEND FROM TstTable 

You should now be able to use the INSERT command with the new table.



STATUS
This behavior is by design. There is no way to predict product behavior when data or index corruption has occurred.



MORE INFORMATION
If you issue an INSERT command similar to the following: INSERT INTO TstTable (TstField) VALUES ("aaaaa") and the index file of TstTable is somehow corrupted, Visual FoxPro will produce the following error and will freeze:

"This program has caused an illegal operation and will be shutdown"

You will be able to exit Visual FoxPro by clicking Close in the error dialog.

Additional query words: kbdse VFoxWin TABLE CORRUPT INDEX

Keywords: KB156581

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.