Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Corrupt table
Message
De
24/04/2014 16:30:14
 
 
À
21/04/2014 12:15:37
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01598836
Message ID:
01599029
Vues:
54
>>Hi All:
>>
>>On a USE, I'm getting the following message:
>>
>>
>>Table 'Foo.dbf' has become corrupted.  The table will have to be repaired before using again.
>>
>>
>>When I run a program (SBT) that uses this table, the system crashes with the following message:
>>
>>
>>Table 'Foo.dbf' has a file length/record count inconsistency.  The table will need to be rapaired before transactions can be committed properly.
>>
>>
>>My question is: Is there a way to repair the table without having to restore from a backup? Note that this table is part of a .DBC database.
>>
>>Thanks,
>>
>>Yossi
>
>
>I don't know why this works, but I received a tip several years ago that sometimes cleans this up.
>SET TABLEVALIDATE TO 0
>USE myTable
>GO BOTT
>BROWSE
>
>Manually append 4 or 5 records (I use CTRL-Y in the browse window) and then DELETE the newly appended records.
>
>It doesn't work all the time, but it works frequently enough to be worth a try.
>
>.........Rich

That seems to have worked. Thanks!

One question: Are there still some gremlins lurking or does this pretty much recreate a pristine header?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform