Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Table Index Question
Message
De
15/08/2003 04:09:51
 
 
À
14/08/2003 16:33:50
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00820323
Message ID:
00820405
Vues:
20
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform