Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Opening tables without indexes
Message
 
 
To
29/10/2002 07:00:49
Philip Jones
Cornwall County Council
Truro, United Kingdom
General information
Forum:
Visual FoxPro
Category:
FoxPro 2.x
Miscellaneous
Thread ID:
00716369
Message ID:
00716399
Views:
18
See Re: Error on NO CDX Thread #583250 Message #583255

>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.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform