Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index on 3 fields at once
Message
From
02/03/1999 13:17:35
 
 
To
02/03/1999 08:57:37
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00192740
Message ID:
00193246
Views:
13
Hi Randy,

Yes, you are correct. Sorry :)

>You don't want to use ALLTRIM there, just STR. Using ALLTRIM will create different length keys for different records, and the ordering will not be correct.
>
>>For example, if first and third is characterm but second is a numeric, you could use:
>>
>>INDEX ON first+ALLTRIM(STR(second))+third TAG IndexName
>>
Phil
_____________________________
Phil Miles
http://www.philmiles.com
phil@philmiles.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform