>I have 2 fox2x format tables that are used by both VFP3 and Fox2.6 for DOS. The larger table contains over 800,000 records, the other contains about 60,000 records.
>
>A partiular index is not working correctly on each table. If I reindex the tables, any new records after that time are not indexed properly.
>
>Table A:
>- 800,000 records
>- index that is not working is
>str(rfid)+dtoc(dx_st_date)+tx_time
>
>RFID is a number
>DX_ST_DATE is a date
>TX_TIME is a char representation of time
>
>If I display the table in a browse or a grid, ordered on this index, the records are not displayed in order.
>
>I have reindexed, packed, deleted and recreated the indexes over and over in the last few weeks. I have even copied the data out of the tables with COPY STRUCT and APPEND FROM.
>
>Any ideas as to what could be happening?
>
>Some other info.
>- tables on Netware 4.11 volume
>- fox2x program feeds data into the two tables 23 hours per day
>- VFP3 displays the tables in grids and runs reports
>- not all tables experience this problem
>- only the indexes with a date mixed with other data types have this problem
>- my date format is YMD and CENTURY is ON

I would suggest using DTOC(date,1) --or DTOS(date), which is the same-- and specifying a length such as STR(number,10).