>All in all, it doesn't really work! :) The real problem (bug, IMHO) is that VFP accepts indexes on variable length
>char expressions. And regardless of any advice you may get from anybody in favor of such indexes, I can't advice
>against enough. The problems generated by such indexes are subtle and, usually, hard to find and hard to fix.
>
>Vlad
Hi Vlad,
In going through the thread yesterday, it turns out VFP doesn't really allow variable length key expressions. It derives the key length from the current record.
So if the record pointer was on a record with a memo field value greater than 240 characters in length, it bombed. The same can be said if the current memo field was empty. But, if the length falls within the valid range then the index is created with the key length matching that record.
As Ed pointed out, this can throw your sorting off if you have values greater in length than the generated key with similar starting characters.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao