Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Multi-column indexes without conversion to text equivale
Message
De
08/02/2001 15:50:16
 
 
À
08/02/2001 15:38:12
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00474159
Message ID:
00474184
Vues:
23
>>This strikes me as being inefficient, since the DTOC() and STR() functions would need to be run on the column data, and I am wondering if you can do this another way.
>>
>>Thanks
>
>As Nick noted, you have to convert them all to be string. But I would use DTOS() not DTOC() so that you're dates will be ordered correctly, no matter what the format is.

Thanks, guys.
I was hoping that I had missed something somewhere.

Hey, Fred, thanks for pointing me to another VFP function DTOS(). I had not ever seen that one. What's interesting is that DTOC has an optional number parameter that states it is for maintaining index expressions (the optional [,1]). DTOS() is quicker to type, if nothing else. Now, on to other things:

I understand that I would have to be careful composing scope clauses, etc., in order for RUSHMORE to kick in and use that compound index...
Jim Newsom
IT Director, ICG Inc.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform