Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SELECTing MAX()
Message
From
13/12/2000 11:40:34
 
 
To
13/12/2000 11:32:19
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00452686
Message ID:
00452910
Views:
26
>>How about this - assuming that id and score are numeric fields
>
>Since you used Transform() an ID of 2 and a Score of 18 they key will be 218 wich will also match with an ID of 21 and a score of 8. Right?

Good point -
That should have been STR() instead of Transform()
Insanity: Doing the same thing over and over and expecting different results.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform