General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
CDX index corruption
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only