Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Selecting the last match
Message
 
To
18/06/2001 00:56:18
Jimi Lee
Pop Electronic Products Ltd.
Hong Kong, Hong Kong
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00520445
Message ID:
00520464
Views:
14
>hi all,
>
>I have this query:
>
>Select a, b, c from MyTable;
>  into array MyArray;
>  where a=MyKey
>
>
>If there are serveral matches in the table, how should I modify this query in
>order to get the last matched one?

One way to do this would be to use the TOP 1 and the ORDER BY myField DESCENDING clauses.
My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform