>>David:
>>
>>A delimiter is absolutely necessary if you use allt() in your index expression because
>>
>>allt(str(1)) + allt(str(23)) is exact than allt(str(12)) + allt(str(3))
>>
>>But if you dont use allt() is not necesary at all. I use str(field1) + str(field2) in several tables and all my seeks works fine always.
>>Carlos.
>
>Carlos,
>Some of my tables have more than 3.5 million records so the CDX becomes very large. On average the ALLTRIM() reduces the size of my CDXs by forty percent because STR() pads strings to the left with 10 spaces. Note: You'll have to reindex after adding the ALLTRIM() to see the size reduction.
>
>However, I did test the seeks on a sample table and you are quite right, it works fine. I guess I established the opinion from some faulty expiraments long ago. If I rediscover the reason for my previous opinion I'll pass it on...
>
>David
David,
Ok. You are right. None of my applications works with more than 100 thousands records, and i'm not in need of reducing size of my cdx files. But i have learned something new. Thanks.
I profit to asking you if VFP databases and tables works fine with so much records.
Carlos.
Saludos,
A.G.P.
---------