Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
LOCATING backwards
Message
From
24/10/2003 12:13:27
Fabian Belo
Independent Developer
Argentina
 
 
To
24/10/2003 12:05:32
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00842157
Message ID:
00842229
Views:
24
Hi Cetin & Fabio;

I think the proper answer to the original question is NO.
The LOCATE command cannot do it. I agree 100% with Cetin's suggestion, however, as Sergey pointed before, some workaround can be done as showed in Fabio's example which doesn't works.
LOCATE command doesn't need any indexes, but in this case I think is the only solution.

Cheers,

>>Sorry Cetin ( fast write )
>>
>>this is correct:
>>
>>CREATE CURSOR t2 (f2 I )
>>RAND(3)
>>FOR K=1 TO 500
>>INSERT INTO t2 VALUES (100*RAND())
>>NEXT
>>SET FILTER TO f2=1
>>GO BOTTOM  && this is sufficient
>>SET FILTER TO
>>BROWSE
>>
>>
>>Fabio
>
>No it's not. What you get is only the last record. A locate command supports continue and found. This doesn't.
>Well suggesting skip -1 would be overkilling. You might not know if intention is doing a scan while...endscan or alike.
>An index is the way to go IMHO. If no index exists creating an index with a dummy key does well (IMHO every table should have such an index) :
>
>index on .t. tag myLocator
>
>set order to tag myLocator descending
>
>Cetin
"Since I've read that alcohol is bad... I quit reading."
Me


http://www.fabianbelo.com.ar
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform