Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding a field to a table
Message
 
To
22/05/2001 12:11:11
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00509924
Message ID:
00509982
Views:
19
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?
Previous
Reply
Map
View

Click here to load this message in the networking platform