Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DBC problems?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00514544
Message ID:
00515246
Views:
14
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
Previous
Reply
Map
View

Click here to load this message in the networking platform