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 03:07:57
 
 
To
10/01/2005 22:10:35
Walter Meester
HoogkarspelNetherlands
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:
00975950
Views:
36
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.

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,
>
>>Remove the ALLTRIM function!!! NEVER, NEVER, NEVER use ALLTRIM in an index expression! And this rule has NO exceptions!
>
>NEVER SAY NEVER :) . The rule is that each index expression should has the same fixed length. ALLTRIM() certainly is a threat but an index expression of:
>
>
INDEX ON PADR(ALLTRIM(FirstName)+ALLTRIM(LastName),40)
>
>is perfectly valid.
>
>Walter,
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform