Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help with error message
Message
From
13/02/2003 16:47:31
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
13/02/2003 16:38:28
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00752912
Message ID:
00752924
Views:
15
>The fields in table ...dbf did not match the entries in the database.
>
>What does this mean and how can it happen and be prevented?

When you create a table in a database, information on the fields is stored not only in the table (DBF) but also in the database.

The error appears when copying a different version (structure) of the table to the database (that is, usually, to the folder that contains your data).

To avoid the error, keep table and database together - don't copy them separately.

As a quick fix, perhaps you can free the table (FREE TABLE). This will lose some information, like long field names.

You might also be able to recover the correct version of the table, ZAP it, and use APPEND FROM, from the wrong version.

HTH,

Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform