Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sorting on 2 different fields together.
Message
From
07/09/2000 12:21:03
 
 
To
07/09/2000 11:04:55
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00412888
Message ID:
00413624
Views:
16
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform