Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Number of records on a filtered table
Message
 
 
À
15/09/2008 21:03:39
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Divers
Thread ID:
01347777
Message ID:
01347781
Vues:
8
>>I have a table that has a filter. If no records satisfy the filter, how can I tell? The RecCount() shows the number in the table, not just those in the filtered result. I need to know if the filtered result is empty.
>
>
>set filter to ...
>go top
>if eof()
>  * Empty
>endif
>
>
>To find the actual number of records, you can use the COUNT command.

GO TOP is not optimizable. The LOCATE is.
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform