Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Find number of records satisfying SET KEY
Message
De
30/06/2011 16:01:11
James Blackburn
Qualty Design Systems, Inc.
Kuna, Idaho, États-Unis
 
 
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:
01516919
Vues:
49
select count(*) from table where (same condition as the set key) will give a count without changing your record pointer.

>>>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.
>>
>>This gives you the "visible" count:
>>count to lnCount
>
>Yes, thanks - thought is there a way without a count? I guess I will go for it.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform