Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can CDX Reference be Removed without Opening Table?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00356049
Message ID:
00356341
Vues:
16
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform