Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows Server 2016
>>>>>>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.
>>
>>Thanks. We'll keep that in mind as a future project because it may cause a lot of changes in code, but I don't think it's the main cause here because we set all the environment in one place and every form, class, etc. use the same setting. So, SET CENTURY and SET DATE (for example) are only set once and never touched afterward.
>
>And that might be your issue as there are some commands (i.e. SET DATE, SET HOURS) that are scoped to the current data session.
Every forms calls the same function that set all environment settings scoped to the current datasession in their LOAD event. So in principle, the settings are the same everywhere, even in the private datasessions.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement