Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can CDX Reference be Removed without Opening Table?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00356049
Message ID:
00356341
Views:
10
Hi Michael.

>Thanks! That worked very well. It was simple to write a short routine to rewrite the table. If the CDX is missing, byte 28 is simply changed to zero(0), unless it has a memo file, which would make it 2. Then, the table can be opened without errors, to rebuild the index.

That won't work if you have a table that belongs to a DBC and that table has a primary key defined. When you try to open the table, you'll get a "primary key missing; please validate database" error.

You might want to consider saving yourself a bunch of time and grief by looking at Stonefield Database Toolkit. It'll resolve the problems you've been working on (recreating a missing CDX) and handles the problem I mentioned here and many others that can occur as well. It'll also handle the issue of updating table structures at your client sites and repair corrupted table and memo headers. For more information or a demo version, please see our Web site.

Doug
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform