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