>Hi all,
>
>I have a web app that relies on VFP data and it runs 24/7. Sometimes, an index entry for a particular record in a table would be corrupt so the code that uses IndexSeek() function cannot find the record. It would be costly for our clients to take the server down to reindex the database frequently.
>
>How do you guys repair the index without taking down the whole system?
>How frequently does this kind of index corruption happen to your data?
>
>Any comments, suggestions will be greatly appreciated.
Do you get any error message?
Add "Flush force" after every update command.