Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Emergency Data Repair Needed
Message
De
06/01/2011 06:34:59
 
 
À
05/01/2011 13:24:34
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:
01494917
Vues:
64
>>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

>I've never used TableValidate for a table not belonging to a database. I know I didn't state that earlier but I was curious. Does that work for stand alone tables as well.

It works. And it´s even better thatn CmRepair. I fixed tables that Cmrepair couldn´t fix. May be I should had try

SET TABLEVALIDATE TO 0

before using CmRepair. I´ll try that next time.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform