>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