Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Adding a field to a table
Message
 
À
22/05/2001 12:11:11
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00509924
Message ID:
00509982
Vues:
20
I think your table is corrupted.

If you can open the table try this:
Use YourTable
copy to NewTable cdx
use
delete file YourTable.dbf
delete file YourTable.fpt  && If you have memo field
delete file YourTable.cdx
rename NewTable.dbf yourtable.dbf
rename NewTable.cdx yourtable.cdx
rename NewTable.FPT yourtable.FPT && If you have memo field


>I've added a new field to an existing table, and am trying to reindex it. Now, I get the error message that the table is invalid and needs to be validated? Also, when I try to open it in the editor, the message that the .dbf file did not match the entries in the database. I've added fields to my tables before and have never had this problem. What did I do differently?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform