Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Emergency Data Repair Needed
Message
De
05/01/2011 13:14:44
 
 
À
05/01/2011 12:16:10
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
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01494778
Message ID:
01494784
Vues:
85
>We have a large table which has given the message "Table '< tablename >' has been corrupted. The table will need to be repaired before using again.
>
>There is no memo file associated with this table.
>
>My experience with repair tools is that they have not been very useful.
>Has that been your experience as well?

We get this occasionally and sometimes the following works. I have no idea why but it may be worth a shot. In the command window we.......
CLOSE DATA ALL
SET TABLEVALIDATE TO 0
USE < tablename >
GO BOTT
BROWSE

< append some blank records > &&anywhere from 3-5 records seems to work
< delete those records >
CLOSE DATA ALL
SET TABLEVALIDATE TO yourvalue
This was a trick that was passed to me by the previous programmer. I have no clue why it works, but in most cases it does the job
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform