Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Table not updating, but fixed with table replacement
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Stonefield
Divers
Thread ID:
00754090
Message ID:
00754681
Vues:
15
Doug
I've implemented the Repair as recommended and compare the calculated and actual file size and run repair when not the same. But when I rerun the program the same files are selected as not being fixed. The difference between the actual and the calculated is 1 always. Any suggestions?

Thanks
Jon

>The problem was most likely that the record count in the header was incorrect. This is an ugly problem, since as you've seen, VFP doesn't give an error when you open the table and TABLEUPDATE() returns .T. A new feature in VFP 8 is that it warns you about this problem when you open the table, but doesn't fix it. The only way to detect it is to check RECCOUNT() and compare it to the size of the table. See the VFP help topic for RECSIZE() for a formula to calculate how big the file should be based on RECCOUNT(), which you can then compare to the actual size retrieved using ADIR().
>
>Doug
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform