>When I erase a cdx file and try to recreate the index, I get the error message "structural .cdx not found" when I open the table and a dialog box comes up with "Cancel ...".
>
>I would like to suppress that error message and have the table open without any user intervention and then recreate the indexes through code. This would be triggered in an error routine for error 114 - Corrupted Index Error.
>
>One thought was to make a copy of the table, erase the original table and index and then rename the table and run the code to create the index. However there must be a better solution than that.
>
>Any help would be appreciated.
>
>Gaylen
Gaylen,
You can use DELETE TAGS ALL command to delete all indexes end erase cdx file.
USE MyTable EXCLUSIVE
DELETE TAGS ALL
INDEX ON ... TAG ...
--sb--