>>>Hi Walter,
>>>
>>>yes, but it your case, why? INDEX ON FirstName-LastName gives EXACTLY the same result! One of the little used features of xBase.
>>
>>This is not true:
>>
>>FirstName-LastName
>>is
>>PADR(RTRIM(FirstName)+LastName,FSIZE(FirstName)+FSIZE(LastName))
>>
>>
>>>
>>>OK, I admit I should have use the word "as", and not "in". 'Never use alltrim
as an index expression. Thank you for the correction.
>>>
>>>>Hi Tore,
>>
>>Then:
>>
>>Never use LTRIM()
>Correct
>
>>Never use RTRIM()
>Correct
>
>>and then
>>NEVER USE OF A VARCHAR FIELD ON VFP9 !
>Wrong. A varchar field has a maximum length which will be the key length
Sure but this is true for a RTRIM(cFiled),LTRIM(cField),ALLTRIM(cField) also:
CREATE CURSOR TEST (FC C(10),FV V(10))
INDEX RTRIM(FC) TAG T1
INDEX FV TAG T2
Try to use a varchar with SET EXACT OFF or SET ANSI OFF !
You will have the time of drink many coffees.