Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
LOCATING backwards
Message
De
24/10/2003 12:13:27
Fabian Belo
Independent Developer
Argentine
 
 
À
24/10/2003 12:05:32
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00842157
Message ID:
00842229
Vues:
25
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform