Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding a field to a table
Message
From
22/05/2001 15:48:10
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
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:
00510043
Views:
29
>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?

You did it while the table was disconnected from the .dbc - this may happen when you have a copy of the table in development, change the structure, and then copy the altered table into the production location, without copying the .dbc as well. The production .dbc will complain like this, because the information about your table is not what table actually has.

My usual cure for this is to do these changes programmatically, i.e. any changes I do to development tables are checked when the executable runs on the user's side, and if they're not done, the production tables are altered. This way each set of tables remains connected to its DBC, never leaving the directory where it resides. The target DBC will automatically register any changes to the table, be they done programmatically or interactively.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Reply
Map
View

Click here to load this message in the networking platform