Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Handling Corrupt Indices
Message
De
28/10/1998 13:55:32
 
 
À
28/10/1998 13:51:16
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00151798
Message ID:
00151801
Vues:
22
Jeff ---

Physically delete the CDX file then open the table (you'll get a structural index not found error if it's the structural cdx...ignore it) -- then recreate the indexes either throught a PRG script or manually.

>I have a general, blood-and-guts question about handling corrupt CDXes.
>
>If you have a scenario where a table's CDX is corrupted to the point that you can't open the table, then what is the approved method of re-creating the CDX so that the file can be opened and reindexed?
>
>There's some legacy code in a system we have that is setting byte 29 of the DBF file to CHR(0) using FWRITE, but this sends shudders down my spine -- even if we find the new "correct" location, it seems sure to change at some point in the future and burn us again.
>
>-- jas
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform