BUG: BROWSE KEY 0 Causes Errors When No Database Order Set

• Microsoft Visual FoxPro for Windows, versions 3.0, 5.0, 5.0a
• Microsoft FoxPro for Windows, versions 2.5, 2.5a, 2.5b, 2.6
• Microsoft FoxPro for MS-DOS, versions 2.0, 2.5, 2.5a, 2.5b, 2.6
• Microsoft FoxPro for Macintosh, versions 2.5, 2.5a, 2.5b, 2.6, 3.0

SYMPTOMS

Issuing the BROWSE KEY 0 command when no order is set in the database causes an uninterruptible "Record Out of Range" error in releases of FoxPro version 2.0 for MS-DOS dated earlier than March 25, 1992. In FoxPro versions 2.5 and 2.5a for MS-DOS and in FoxPro versions 2.5 and 2.5a for Windows, an unrecoverable error of "Index Does Not Match Table Recreate Index" error occurs. The only way to exit from this error is to reboot your computer.

STATUS

Microsoft has confirmed this to be a problem in FoxPro 2.0 for MS-DOS. This problem was corrected in FoxPro 2.0 for MS-DOS dated March 25, 1992. However, later versions of FoxPro 2.0 for MS-DOS will cause a "Record Out Of Range" error. To recover from this error, press the ESC key, or program an ON ERROR routine to trap for error number 5.

Microsoft has also confirmed this to be a problem in FoxPro 2.5, 2.5a, 2.5b, and 2.6 for MS-DOS and in FoxPro 2.5, 2.5a, 2.5b, and 2.6 for Windows. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.