Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Index Key() in dbc
Message
 
À
15/02/2008 17:59:32
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8 SP1
Divers
Thread ID:
01293111
Message ID:
01293114
Vues:
28
A CDX flag (0x01) is stored in the table header at offset 28.
Make backup and replace it with 00.

>There were problems with re-indexing the tables from a propritary package we use. The vendor is looking into it but I'm trying to lend a hand.
>
>The CDX file for the table no longer exists.
>
>I can open the table (I guess the CDX reference was removed from the table).
>
>However, if we do a SQL SELECT from the table the result is the infamous C000... error and VFP crashes.
>
>When I look at the DBC I can find the table and it's child records. There are four index records. I'm assuming objectname in the dbc is the TagName. However, I can't seem to find the KEY() information.
>
>Is that stored anywhere other than the CDX itself? If so, could somebody point me to where and to some documentation on how to decipher it (assuming it's not ASCII)
>
>Thanks......Rich
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform