Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index Key() in dbc
Message
 
To
15/02/2008 17:59:32
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
01293111
Message ID:
01293114
Views:
26
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
Previous
Reply
Map
View

Click here to load this message in the networking platform