General information
Title:
Opening tables without indexes
Hi,
We have some code that runs overnight which reindexes all of the tables in an application. It opens each table exclusively and issues a DELETE TAG ALL.
It then adds each index back in again.
Occasionaly we have problems that are caused by the fact that sometimes the whole cdx file seems to get corrupted. Deleting and restoring individual indexes does not fix the indexes and the only way to fix them is to delete the whole cdx file, open the table without it, and recreate all of the indexes.
So.. I would like to alter the code that runs overnight to delete the entire cdx file.
However.. If I delete a cdx file and then USE the relevant table I get a message tellnig me "Structural CDX file not found", and giving me two options "ignore" and "cancel". If I was adding the indexes back in manualy I could just click cancel, but I need my code to handle this.
Does anyone know if there is a command I can use to open the table regardless of whether the cdx file associated with it has been celeted or not.
Phil.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only