Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Opening tables without indexes
Message
From
29/10/2002 07:17:57
 
 
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:
00716374
Views:
11
Phil,

DELETE TAG ALL already does exactly that. From the Help:

ALL [OF CDXFileName]
Removes every tag from a compound index file. If the current table has a structural compound index file, all tags are removed from the index file, the index file is deleted from the disk, and the flag in the table's header indicating the presence of an associated structural compound index file is removed.

cheers

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

Click here to load this message in the networking platform