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

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

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.

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

If you issue an INSERT command similar to the following: and the index file of TstTable is somehow corrupted, Visual FoxPro will produce the following error and will freeze: You will be able to exit Visual FoxPro by clicking Close in the error dialog.