Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Way to find out if filter results in records
Message
 
 
À
23/06/2011 09:31:59
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 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01515632
Message ID:
01515701
Vues:
47
>>>But you did not want to (or preferred not to) move the pointer, something that COUNT FOR will do.
>>
>>Yes, that's true. But I have LOCATE command after COUNT is done, so everything seems to be OK.
>
>It seems to be OK, but it is not. The SQL command that Hugo gave you is a good way to do this. By using SET FILTER and COUNT and LOCATE you are causing the computer to do much more work than it should.

I can use SQL, but then I will need to use with buffering clause as I'm changing the bottom view.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform