Microsoft KB Archive/176829

= FIX: "Index Internal Consistency Error" Occurs with IDX Index =

Article ID: 176829

Article Last Modified on 5/12/2003

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition
 * Microsoft Visual FoxPro 3.0b Standard Edition
 * Microsoft Visual FoxPro 5.0 Standard Edition
 * Microsoft Visual FoxPro 5.0a
 * Microsoft Visual FoxPro 3.0b for Macintosh

-



This article was previously published under Q176829



SYMPTOMS
When you use an IDX index on a Visual FoxPro table, you may receive the following error while scrolling through the data in a Browse window:

Index Internal Consistency Error.

Visual FoxPro shuts down after you click the OK button. This only seems to occur when the table is buffered.



RESOLUTION
Add the COMPACT clause to the INDEX command. For example, use the following command to create a compact index: INDEX ON TO COMPACT



STATUS
Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article. This has been corrected in Visual FoxPro 6.0.



MORE INFORMATION
The problem occurs after an IDX index is created and used with the table. When the user browses the table and changes the data in the indexed field, moving up or down in the Browse window several times with the arrow keys, the scroll bar, or the Page Up and Page Down keys produces the error.

Steps to Reproduce Behavior
  Run the following code from a .prg file or the Command window in Visual FoxPro: INDEX ON TO COMPACT USE HOME+"samples\data\customer" COPY TO HOME+"Test.dbf" SET MULTILOCKS ON     USE test INDEX ON cust_id TO junk  &&  COMPACT =CURSORSETPROP("Buffering", 5) BROWSE  When the Browse window appears, change the data in the cust_id field. Press the Down arrow key and move through the records to the end of the table. If necessary, press the Up arrow key and move through the records to the beginning of the table. The error should appear. Sometimes moving through the data with the Page Up and Page Down keys also causes the error. Remove the "&&"s from in front of the COMPACT clause in the code above and rerun the code to rebuild the index. The error does not occur when you scroll up and down in the Browse window after changing data in the index key field.

Additional query words: kbvfp600fix

Keywords: kbbug kbfix KB176829

-

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

© Microsoft Corporation. All rights reserved.