Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Corrupt Index
Message
 
À
18/08/2005 15:04:26
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Novell 6.x
Database:
Visual FoxPro
Divers
Thread ID:
01042048
Message ID:
01042051
Vues:
18
One of the solutions:
RELEASE aa
ON ERROR AERROR(aa)
USE c:\coops\sta_mstr 
on error
IF type("aa[2]")="C" and "index corrupted"$aa[2]
* reindex 
endif
But I would not do it this way. I would first investigate the cause of corruption in the code. Also if the table is part of the database, then probably you should validate the database and/or perform other steps for maintenance.

>On one form of mine, I use a table which is local and used exclusive. Thie table often has it's index become corrupt and gives the message ...Tablename or one of it's members... index may have become corrupt or missing... This is always a small table and since it is local and exclusive, it would be easy to simply rebuild the index quickly when this error occurs. Is there some coding that will tell me when this specific error occurs so I could rebuild it if this condition is true other than using the general on error check?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform