Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Database Corrupted
Message
 
À
27/08/2002 12:47:28
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00694100
Message ID:
00694282
Vues:
7
>Dear Friends
>
>Due to power failure, the database get corrupted. I issue the
>VALID DATABASE command.
>
>It give message :
>
>The fields in the table 'tablename' didnot match the entries in
>the database.
>
>I corrected the problem by issuing following command
>in command box:
> OPEN DATABASE 'DatabaseName'
> MODIFY DATABASE
>
> Then remove the table from the database and again add the
> table into the database.
>
>Is there any other way to solve the problem ie by issuing command only?

One thing is to ALWAYS have a copy of your database containers. This is because in my experience power failures and such tend to damage the database container. The easiest way to fix this is replace the bad one with a known good backup copy.
Cy Welch
Senior Programmer/Analyst
MetSYS Inc
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform