Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Dbf won't pack
Message
De
17/12/2011 06:49:17
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
01531179
Message ID:
01531252
Vues:
52
>Hi,
>I have a old client that has contacted me because he is getting strange results from queries etc.. There are several tables in the DBC that
>will not pack (this is VFP6) and they are very large (all three over a gig each). I have a tool "ADR" from the past and I used on the tables.
>The tool did not repair the tables, fpt's, and cdx's. It did create tablename_fixed.* files but they too will not pack. Strange - two of the tables will
>allow" pack memo". Also the same two dbf's will allow a reindex. The error message is "Data mismatch" and then stops.
>
>Does anyone have a suggestion or a better tool to fix the tables?

I'd start by writing out each record into an sdf file or copy or select *, recno() into table -
find out if it is something on one of the data sectors and create "other" backup at the same time ;-)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform