Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
DBC problems?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00514544
Message ID:
00515246
Vues:
15
Doug,
thanks for the help. The header should be ok. Our reindex prg checks the header against the file length and fixes it if there is a problem after backing the file up. It then packs the file before deleting all index tags and creating new ones. The DBC is packed before all this happens. I'm trying to see if anyone has ever seen a DBC problem cause table update problems. The Validate Database returns no errors. I am thinking of writing a prg to create a new DBC as part of the update but don't want to do it unless there is some chance it will fix the problem.

John.


>Hi John.
>
>> The problem happens when new records are added.
>
>This likely isn't a DBC problem but a table header corruption problem. There's a known bug in VFP that causes records to be incorrectly added to a table (usually by overwriting an existing record) when the record count in the table header is incorrect. Simply PACKing the table will resolve the problem.
>
>Doug
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform