>>>We have an index that keep corrupting all the time. Even if I delete the table, rebuild it from scratch and recreate the indexes, the same index will eventually corrupt itself again. Allways the same index and allways the same table.
>>>
>>>Except for power failure or application shutdown in a middle of a write, what can cause this ? And how to avoid it ?
>>>
>>>TIA
>>
>>What is the index expression?
>
>It's a combined fields index : NO_PARTEN+DTOC(DTPREL)+STR(IDCARTE,2)
Use DTOS instead of DTOC. I think DTOC function is not good as part of index expression as it's settings dependent.
If it's not broken, fix it until it is.
My Blog