Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Memo file corruption?
Message
 
 
À
02/03/2006 10:44:27
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Novell 6.x
Database:
MySQL
Divers
Thread ID:
01100892
Message ID:
01100991
Vues:
13
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform