Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Index on multiple integer fields
Message
 
À
19/12/2005 13:36:47
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows 2000 SP4
Database:
Visual FoxPro
Divers
Thread ID:
01079271
Message ID:
01079280
Vues:
22
>>A quick question. If I need to build an index tag on two integer fields do I still need to convert them to strings? Or is there a better way in VFP9?
>>
>>old way:
>>index on str(psfkjob,10,0) + str(psshipper,10,0) tag psjobship
>>
>>Thanks,
>>Margaret.
>
>
>* correct way:
>index on BINTOC(psfkjob) + BINTOC(psshipper) tag psjobship
>
Fabio,
Is the speed better with BINTOC() in comparison with STR() ?

TIA
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform