Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Get error - 'Fields in table ...did not match..'
Message
From
07/07/1999 12:08:47
 
 
To
07/07/1999 09:06:17
Alicia Ross
Statistics Canada
Ottawa, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00238203
Message ID:
00238354
Views:
10
Hi Alicia.

>'The fields in table tableX did not match the entries in the database'

This error indicates that the table structure doesn't match the database container. VFP doesn't care about field name or data type changes (since it doesn't keep them in the DBC anyway), but will give this error if the table physically has more or fewer fields than the DBC knows about.

I'm guessing that the Setup Wizard may be grabbing an older copy of the table (for example, you copied that table from an older directory or restored it from a backup). The only real solution is to find a current copy of the table and overwrite the older one.

If you're interested in seeing exactly what the differences are, make a backup of the DBC and table in question, then FREE TABLE [table name] (so you can open it), USE [table name], and LIST STRU. Then open the DBC as a table (USE [database].DBC) and browse it. Find the record with ObjectType = "Table" and ObjectName = name of the table and note the ObjectID. Then look for record with ParentID = the table's ObjectID and ObjectType = "Field", and compare it to the LIST STRU.

Doug
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform