Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Find number of records satisfying SET KEY
Message
De
12/07/2011 10:41:05
Mike Yearwood
Toronto, Ontario, Canada
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01516912
Message ID:
01517962
Vues:
109
>>>Hi everybody,
>>>
>>>I made a change in my form to use SET KEY instead of original SET FILTER. Everything seems to be working OK, but I still have a question - how wll I know the number of records satisfying the KEY (e.g. the number of filtered records)?
>>>
>>>The _TALLY variable doesn't work.
>>>
>>>I actually only need to know if I filtered something or not, although I created a variable for the number of filtered records. So, I can change it to logical variable, if you know an easy way to find if I filtered something or not, although I prefer to have a number.
>>>
>>>Thanks a lot in advance.
>>
>>_TALLY can work:
>>
>>COUNT
>>? _TALLY
>>
>
>You need to count first.

Counting with SET KEY is extremely fast, much faster than a SQL. If the count is non-zero you have your logical test too. Since it was my suggestion to go with SET KEY, you're welcome.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform