Microsoft KB Archive/103490

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 15:03, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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.