Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SET FILTER Question?
Message
De
18/04/2007 07:00:04
Mike Yearwood
Toronto, Ontario, Canada
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01212448
Message ID:
01217226
Vues:
19
>>>>Hi Hilmar,
>>>>
>>>>That's what I thought it meant. Yes, the cursor alias is current. I guess I am just used to specifying it that way. But thanks, I will keep that in mind.
>>>>
>>>>Thanks,
>>>>Sam
>>>
>>>
>>>If you haven't used SET FILTER much, the one gotcha you need to watch out for is it doesn't take effect until you move the record pointer. Usually GO TOP is what you do.
>>
>>No. If you use SET FILTER you want to use LOCATE, not GO TOP. GO TOP is not Rushmore optimizable.
>
>
>Smacking forehead! I actually knew that, just replied too quickly. There is also a trick for doing an optimizable replacement of GO BOTTOM. You set the index to Descending (if it isn't already), then LOCATE. That leaves you on the last record. Then return Descending() to its previous state. I have no doubt you already knew that....

Yep! I wrote it in FoxPro Advisor July 1997. ;)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform