Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Get table size to check header corruption
Message
 
À
28/04/2003 10:34:57
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00781935
Message ID:
00782251
Vues:
17
I believe, the file is OK and you should not do anything with it. It may not contain the file end mark. Check out the very last character: it should be chr(26) if it is the end mark.

Actually you need to repair the file if you cannot open the table getting "NOT a table" error. As a rule it indicates that the number of records in the header is not correct, and in this case you need to replace this number in the header. AFAIK, VFP versions 6 and 7 usually do not display the error and adjust the header automatically with the subsequent table updates. VFP8 does not do it.


>Hi,
>OK. I have check the the other table. I found that it missing 1 byte only happen to aparticular file. The file still can be open, insert/update without problem. So, How to repair it? I try pack, zap, modi structure, recreate the table using AFIELD() and CREATE TABLE FROM ARRAY also the same.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform