Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CDX index corruption
Message
From
05/09/2000 09:49:27
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
CDX index corruption
Miscellaneous
Thread ID:
00412442
Message ID:
00412442
Views:
44
Can anybody suggest how to overcome the following problem
with Visual FoxPro 6.0:

We have relativly big table (in database container):
approximately 100 MB DBF part of it and 25 MB CDX part.
The table is heavyly used in network encironment
(Windows NT 4.0 or Novell Netware 4.11)
from 25-30 workstations, and most users add records.
Form is using private data session, multilocks is set to ON,
buffering is set to table optymistic (5).

Sometimes it happens that record is added to table (it is
in DBF file), but there is no entry in CDX file.
Unfortunatelly in this case TABLEUPDATE returns TRUE,
so we issue END TRANSACTION and in the result index is corruped.
Reindex clears the problem, but that is not a solution.

Janusz Wojtukiewicz
Next
Reply
Map
View

Click here to load this message in the networking platform