Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
LOCATING backwards
Message
From
26/10/2003 11:59:42
 
 
To
25/10/2003 13:05:16
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00842157
Message ID:
00842737
Views:
22
>Hi Peter
>
>Sorry to jump in. Just to make things clear, you can NOT use locate to do this, because locate will trigger VFP to try to optimize the search, and will then by itself use the indexfile in ascending order. To get the desired result, the last matching record, you must use the following code:
>
>
>USE yourfile ORDER yourindex DESCENDING
>SEEK yourvariable
>(or SEEK(yourvariable)
Hi Tore,

You're right. I assumed an index too easliy. :)
Groet,
Peter de Valença

Constructive frustration is the breeding ground of genius.
If there’s no willingness to moderate for the sake of good debate, then I have no willingness to debate at all.
Let's develop superb standards that will end the holy wars.
"There are three types of people: Alphas and Betas", said the beta decisively.
If you find this message rude or offensive or stupid, please take a step away from the keyboard and try to think calmly about an eventual a possible alternative explanation of my message.
Previous
Reply
Map
View

Click here to load this message in the networking platform