Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table Structure Difference Between 7.0 and 9.0?
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01422262
Message ID:
01422267
Views:
61
As Matthew wrote, use Tablevalidate. The reaason why you see this, is that VFP9 does more error checking, meaning that you may have had data corruption for a long time, without knowing it. VFP9 will let you know so you can fix it.

>I do a lot of automated reporting using Cognos Impromptu v7.3, where the query results are exported to a DBF. FoxPro then generates a formatted Excel spreadsheet, prior to emailing the file as an attachment. I'm in the process of migrating my applications from VFP 7.0 SP1 to 9.0 SP2.
>
>VFP 9.0 is unable to open the DBF generated by Cognos Impromptu. The error it reports is "Table [name] as become corrupted. The table will need to be repaired before using again." The description of the error says that "Either the table record count does not match the actual records in the table, or the file size on the disk does not match the expected file size from the table header."
>
>However, VFP 7.0 has no trouble opening the DBF, and this is the first time I have encountered this problem.
>
>Have the table specifications changed after VFP 7.0? It appears that VFP 9.0 has a stricter specification, or Cognos Impromptu 7.3 is not compatible with VFP 9.0.
>
>---Michael
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform