Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reason for index corruption?
Message
From
18/09/2006 08:24:52
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Reason for index corruption?
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Novell 4.x
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01154622
Message ID:
01154622
Views:
85
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?
Christian Isberner
Software Consultant
Next
Reply
Map
View

Click here to load this message in the networking platform