Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index keep corrupting
Message
From
05/10/2018 10:22:23
 
 
To
30/09/2018 13:35:29
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:
01662478
Views:
36
>>>>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)
>
>Can DTPREL ever be .NULL.?

The field is defined as NOT NULL
Previous
Reply
Map
View

Click here to load this message in the networking platform