General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
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