Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with DBF
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00765052
Message ID:
00765070
Views:
22
Rodolfo,

Typically it happens when the WS crashes with tables open especially when records are being appended resulting in a corruption of the table header which among other things hold info. about no of records in the table.

It's common and recommended to have a utility program that reindex and rebuild tags for each table which should be run every week to 2 weeks depending on the usage of the App. In some rare cases reindex and pack commands don't solve the problem and a dumping and recreation of tags have to take place. This has been an ongoing problem and limitation with FP tables since the begining of time and so far hasn't been dealt with which is a serious limitation to VFP as a backend compared to more solid backends like MS SQL or Oracle.

You could try to minimize that occurance by opening tables as needed in case you open a bunch of tables in launching the App.
Previous
Reply
Map
View

Click here to load this message in the networking platform