>>>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
OK, then I have no tips. I suspected an index expression which could give a variable length key, like alltrim() and trim(), such keys are "time bombs".