Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
The best way to use a portion of a field for indexing
Message
From
11/01/2005 07:14:50
 
 
To
11/01/2005 06:02:22
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00975802
Message ID:
00975978
Views:
35
>>>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
* INDEX T1 AND T2 ARE EQUAL, EXACTLY EQUAL
Try to use a varchar with SET EXACT OFF or SET ANSI OFF !
You will have the time of drink many coffees.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform