BUG: COPY TO WITH CDX Causes to .CDX to Become Corrupt

ID: Q111756

The information in this article applies to:

• Microsoft FoxPro for Windows, versions 2.5, 2.5a, 2.5b, 2.6
• Microsoft FoxPro for MS-DOS, versions 2.0, 2.5, 2.5a, 2.5b, 2.6
• Microsoft FoxPro for Macintosh, versions 2.5b

SYMPTOMS

When the COPY TO command is used with the WITH CDX clause, the .CDX file will become corrupt when following conditions are present:

• There are deleted records in the table.
• SET DELETED ON is set.
• The COPY TO ... WITH CDX command doesn't have a FOR or WHILE clause.

RESOLUTION

To work around this problem, use a FOR or WHILE clause with the COPY TO command. For example:

   COPY TO <filename> WITH CDX FOR .T.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Steps to Reproduce Problem

Run the following program:

   CLEAR ALL
   CLOSE ALL
   SET DELETED OFF
   CREATE TABLE original (idnum C(3))
   FOR i = 1 TO 100
        INSERT INTO original (idnum) VALUES ( STR( m.i, 3, 0 ) )
   ENDFOR
   INDEX ON idnum TAG idnum
   DELETE FOR RECNO() % 10 = 0
   USE
   USE original
   SET DELETED ON
   COPY TO t_copy WITH CDX

   USE t_copy ORDER idnum
   IF SEEK( " 10" )
        WAIT WINDOW "Seeking 'idnum 10',  we found " + idnum + ;
        ". But we shouldn't have found anything."
   ENDIF