>FoxPro is no Oracle.
Thank goodness! :)
Any chance you are adding records without the index open? Such as from something other than VFP. Because if you add records to a .DBF from another program and the other program doesn't open the .CDX than it won't update the .CDX.
The other thing that I would suggest is rebuilding the index from scratch rather than issuing the REINDEX command. Whenever we put a pack/reindex feature in an application we always delete the .CDX file first and then use the INDEX ON command to rebuild the index.
Hope that helps,
Don
>FoxPro is no Oracle.
>
>:)
>
>We've got a large app, cosntantly appending records to a table (a large table).
>
>On occasion, not often, the records will be appended to the DBF but the CDX will not get updated with the approp. tag records. THUS, the app cannot find the records that do exist (but the index tags are missing).
>
>WE CAN Fix this with Pack/Reindex of the tables, but just wondering WHY this happens? We are running VFP5 for this particular app and have a mixture of win95/win98/win2000 clients accessing this DB.
>
>WHATCHUALL THINK?
>THANKY'ALL. Pease don't tell us to convert to oracle ;)