Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Corrupted table in VFP 8.0 can be opened by VFP 5.0
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00913542
Message ID:
00913552
Vues:
14
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform