Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index keep corrupting
Message
 
 
To
25/09/2018 11:18:03
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Network:
Windows Server 2016
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01662237
Message ID:
01662256
Views:
57
>>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform