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.
Additional query words: kbdse VFoxWin TABLE CORRUPT INDEX
Keywords: KB156581