Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sorting on 2 different fields together.
Message
De
07/09/2000 12:21:03
 
 
À
07/09/2000 11:04:55
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00412888
Message ID:
00413624
Vues:
15
>Silly me! By being the two fields integers, the expression field1+field2 was summing, not concatenating the two values. Am I right?. As a matter of fact those two fileds didn't have to be numeric. What was I thinking? :(
>Well, another thing learned. :)
>
>Ulises

Glad to see you figured out the problem. You're correct, it was summing the fields, not concatenating them. You can convert these fields to a string for indexing purposes (See the STR() function), or since you say these fields shouldn't have been numeric in the first place, that will also solve the problem.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform