Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deleting the index
Message
From
20/04/2005 13:20:24
 
 
To
20/04/2005 12:55:05
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01006573
Message ID:
01006631
Views:
23
>>>Hi All
>>>
>>>I have a table with an associated cdx. If I delete the cdx file and open the table in VFP IDE the table opens normally and the status bar says that the "structural cdx reference has been removed". This is fine.
>>>
>>>When I delete the cdx and try and open the file from within my exe app then an error occurs. How can I avoid the error and allow my app to open the file normally but just without the cdx file?
>>
>>Don't know if it's what you want to do, but IIRC DELETE TAG ALL on an open table completely deletes the .CDX.
>
>Hi Al. Yes I know but my question was if the cdx file is already missing then it generates an error when opening the dbf in an app or exe. Sergey has offered some solutions in this thread. Thanks.

OK, I read your original message to mean you wanted to purposely delete your own .CDX file. When in fact, you want to recover from the condition where the .CDX has already been badly damaged, deleted or is otherwise unavailable.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Reply
Map
View

Click here to load this message in the networking platform