Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Table is corrupt in 8.0 not in 5.0
Message
 
À
01/09/2005 10:41:21
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Database:
MS SQL Server
Divers
Thread ID:
01045822
Message ID:
01046743
Vues:
29
Pascal,

>
> I can open, browse and do stuff with a certain table in
> VFP 5.0. When I try to open it in 8.0, it says the table has become corrupt....
>

That normally means the table really *is* corrupt, in VFP5 as well as in VFP8. Only VFP5 doesn't check it. It may still work for 99.99% of the reccords but it definitely is corrupt. Reindexing might seem to fix the problem because the index directs to the discrete positions in the table and thus "hides" the corrupted area (as You said for a while).

As others stated, there is SET TABLEVALIDATE in VFP 8. However I would NOT simply set it to 0 as that does not cure the problem. Either You do have a tool like FoxFix or You could do the following:

- SET TABLEVALIDATE to 0, so You can work with the table
- Copy DBC and DBF (+ additional files like FPT etc.) into a TEMP-Directory
- Select the TEMP-Directory and completely zap the table - even better recreate it from scratch.
- Append the records from the original table
- copy the new table back to its original location. (make another backup, just to be sure)
- reSet TABLEVALIDATE to a value it kicks in.

That should really get the corrupness out of the table.


HTH
Regards from Berlin

Frank

Dietrich Datentechnik (Berlin)
Softwarekombinat Teltow (Teltow)

Frank.Dietrich@dd-tech.de
DFPUG # 327
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform