>Sometimes (it is not repeatable) when I add a record to the table,
>the record is not added to the indexes but can be found in the table
>without index. No error messages. Only a few records (< 50).
>
>I think that the index is updated automatically. How is it possible
>that this update doesn't work?
>
>After a reindex the record can be normally accessed via the index.

Hi Andreas,

The indexes are updated automatically, and normally work just fine. You probably have a corrupted index, because the record showed after you reindexed.

If you used the REINDEX command, you may not see the problem again, but you may still have some corruption, too. You might want to DELETE TAG ALL. This completely deletes the .CDX file. Then rebuild the indexes by hand for a clean file. But be careful! In VFP 5 (and probably 3) DELETE TAG ALL also deletes all relations set up, as well as a bit of referential integrity. You'll have to rebuild those things, too.

Many of us had utility programs to do this for FoxPro 2.x. Most who I've talked to who want to do this in VFP use the Stonefield Database Toolkit. (Stonefield is advertised above as I type.) I've built my own Reindex utility by figuring out what GenDbc.prg does.

Steve