PRB: Records Seem Missing from FoxPro 2.5 Table in Later Vers

ID: Q127873

The information in this article applies to:

• Microsoft FoxPro for MS-DOS, versions 2.5a, 2.5b, 2.6, and 2.6a

SYMPTOMS

CDX tags containing a conditional test for the length of the key expression may return a different result set between FoxPro version 2.5 for MS-DOS and FoxPro version 2.5a (or higher) for MS-DOS, where trailing spaces (blanks) are stored with keys or are used to search for keys.

This problem occurs only when using an untouched version 2.5 table and CDX in a later version.

CAUSE

There was a minor change in how the CDX tag is stored and read from the CDX file between version 2.5 and later versions. This change was made to accommodate index key construction for other-than machine collation sequences.

RESOLUTION

Reindex the file in the current version.

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce Behavior

1. Copy and run the following code in FoxPro version 2.5 for MS-DOS:

   CREATE TABLE cdxtest (f1 C(10))
   INDEX ON f1 TAG f1 FOR f1 <> "ABCD"
   APPEND BLANK
   REPLACE f1 WITH "ABC"

   * Find a string with no trailing blanks
   ? "'ABC'"
   SEEK ("ABC")
   ? FOUND()                && Returns true in all versions

   * Find a string with trailing blanks
   ? "'ABC '"
   SEEK ("ABC ")
   ? FOUND()                && Returns true in 2.5

   USE C:\fpd25\cdxtest ORDER f1  && Open the file created in 2.5

   * Find a string with no trailing blanks
   ? "'ABC'"
   SEEK ("ABC")
   ? FOUND()                && Returns true in all versions

   * Find a string with trailing blanks
   ? "'ABC '"
   SEEK ("ABC ")
   ? FOUND()                && Returns *FALSE* until reindexed.

   that the second SEEK where the string has trailing blanks is found this
   time.