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
Jim Nelson
Newbury Park, CA