FoxPro 2.0 Database out of Order with UNIQUE Indexes

ID: Q103490

The information in this article applies to:

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