Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Reason for index corruption?
Message
 
 
À
18/09/2006 08:27:59
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 9 SP1
OS:
Windows XP SP2
Network:
Novell 4.x
Database:
Visual FoxPro
Divers
Thread ID:
01154622
Message ID:
01154625
Vues:
31
>>Hello,
>>
>>At one client it happens very frequently that the index of some tables gets corrupted.
>>
>>My guess is that the network connection is not very stable, but they checked the connection and say there should be no problems with the network.
>>
>>Yesterday a table got corrupted with the message (when appending a record):
>>
Index file "c:\Cinemas\transactions.cdx" tag "Trusedt" is corrupted. Please rebuild it."
>>
>>After that we suggested to run the program locally on the computer. I issued a REINDEX and they worked again. After 20 minutes the same message appeared.
>>
>>Then I deleted the CDX file and created the indexes again. That seemed to have helped, but I am not sure what causes this problem.
>>
>>The other strange thing is that this program does not alter the field Trusedt.
>>
>>Any ideas where I can look for a solution?
>
>What are the index expressions?

All indexes in this table are regular field expressions. That particular index is:
trUsedT TAG trUsedT
Christian Isberner
Software Consultant
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform