Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo file corruption?
Message
 
 
To
02/03/2006 10:44:27
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Novell 6.x
Database:
MySQL
Miscellaneous
Thread ID:
01100892
Message ID:
01100991
Views:
14
Jon,

It's not the foxuser.dbf (the resource file) that suffers index corruption. It your application tables themselves. Unfortunately these errors usually manifest themselves in the middle of a SQL-SELECT command or SEEK and it's pretty hard to catch them before hand. You could write a maintenence app that exercises all of the indexes, but it'll have to write its progress out to an external datastore that it can reread post C05 error to determine the candidate corruption.

Look at this list of Wiki articles http://fox.wikis.com/wc.dll?Wiki~CategoryDataCorruption

>I'm in the midst of tracking some c0000005's..I see everywhere that people say that FOXUSER.DBF index corruption is often the cause of some of these errors.
>
>My question is, is there a way to tell whether or not a .DBF contains corruption *before* attempting to reindex/recreate it?
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Reply
Map
View

Click here to load this message in the networking platform