Microsoft KB Archive/103490

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

FoxPro 2.0 Database out of Order with UNIQUE Indexes

ID: Q103490

The information in this article applies to:

  • Microsoft FoxPro for MS-DOS, version 2.0

When you are using UNIQUE indexes, FoxPro 2.0 for MS-DOS can exhibit, under simultaneous-update conditions, key loss and/or out-of-sequence keys.

This problem occurs with any UNIQUE index when multiple users are updating the key(s) at the same time. The effects of this problem are especially noticeable in .CDX files.

To correct this condition, reindex the database.

To avoid this condition, either don't use UNIQUE indexes, or upgrade to FoxPro 2.5 for MS-DOS.

Additional reference words: FoxDos 2.00 2.50 UNIQUE INDEXES KEY KBCategory: kbprg KBSubcategory:


Last Reviewed: April 17, 1995
© 1999 Microsoft Corporation. All rights reserved. Terms of Use.