Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Strange CDX corruption
Message
De
17/03/2011 17:04:14
 
 
À
17/03/2011 16:34:55
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
Database:
Visual FoxPro
Divers
Thread ID:
01504018
Message ID:
01504026
Vues:
85
Yes and no; that's in fact rule no. 4: If you absolutely need to use alltrim() since there are no other options, you must use padr() to make sure that you end up with keys with the same length.

>All rules have exceptions:
>
>Using Padr() on the whole group of AllTrims (or any other Trim) gives you keys of all the same length.
>
>
>>Rule no. 1: Never use alltrim() in an index expression
>>Rule no. 2: Never, NEVER, NEVER use alltrim() in an index expression
>>Rule no. 3: If you need to use alltrim() in an index expression, see rule no. 1 and 2.
>>
>>NB! In case I forgot to mention it: Never use alltrim() in an index expression!!!
>>
>>>Hi All
>>>I have an app with VFP database running on o server2003 with 20 clientes in a stable network.
>>>In my databse I have a table XXX with an index like this: cClientType+ALLTRIM(cClientId)+ALLTRIM(cDocType)+STR(nDocNum)+STR(nAnotherField)
>>>
>>>Everythig runs weel except with 2 clients (of 1500) when I make an INSERT INTO XXX (...) ... I get the error Index file "z:\data\xxx.cdx" tag "Misto" is corrupted. Please rebuild it.
>>>
>>>Another strange thisg is that if I use vfp command window and make that inser it runs good!!!
>>>
>>>Any ideas would be great. By the way, is there any way new to rebuild without EXCLUSIVE?
>>>
>>>Thank's in advance,
>>>NPedro
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform