Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Index keep corrupting
Message
De
05/10/2018 10:22:23
 
 
À
30/09/2018 13:35:29
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Network:
Windows Server 2016
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01662237
Message ID:
01662478
Vues:
37
>>>>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform