Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Corrupted table in VFP 8.0 can be opened by VFP 5.0
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00913542
Message ID:
00913552
Views:
15
>I have a table created by VFP 8.0 and also running on an application compliled by VFP 8.0 which being report corrupted and can not be used by VFP 8.0 application. I tried to open that table using VFP 5.0 and it works. Well I hope this information can be usefull to others.

This should allow you to open it in VFP8:
SET TABLEVALIDATE TO 0

Of course that's not really fixing the problem with the table..its just turning off the tablevalidtion.
The best way to fix the table is to add a new field, then remove it...something like this:

lcTableName = GETFILE('DBF','Select Table To Fix')
lcTableValidate = 'set tablevalidate to 0'
&lcTableValidate

use &lcTableName exclusive

alter table &lcTableName add column vvvxxxvv c(1)

alter table &lcTableName drop column vvvxxxvv
use

lcTableValidate = 'set tablevalidate to 3'
&lcTableValidate


....the reason for the macro substitution is so that it will still compile in the older version of VFP. (there is no 'tablevalidate' in the older versions...
ICQ 10556 (ya), 254117
Previous
Reply
Map
View

Click here to load this message in the networking platform