Will REINDEX fix it? You must have the file open exclusively.
USE <tablename> EXCLUSIVE
REINDEX
If it is still corrupted, you may have to rebuild the master index (MDX). See my Dec 15 post in thread290-729294 but before you delete any index tags be sure to first DISPLAY STATUS when the file is open so you can view and record every index tag name and expression.
FAQ290-4606 may be helpful when trying to determine whether there is bad data in the table which can scramble index behavior.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.