Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table Index Question
Message
From
15/08/2003 04:09:51
 
 
To
14/08/2003 16:33:50
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00820323
Message ID:
00820405
Views:
21
Hi,

>
I am trying to make a index on 2 fields. The index needs to sort by the first column and the second column and they are both numberic fields.
>

Indexing on the string value will not give the sort order you require. If the field sizes are as shown (i.e. xx.xxx for both fields) then you could try indexing on 'BINTOC(col1*1000)+BINTOC(col2*3)'

HTH,
Viv
Previous
Reply
Map
View

Click here to load this message in the networking platform