Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Way to find out if filter results in records
Message
De
23/06/2011 13:34:44
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:
01515729
Vues:
61
This message has been marked as the solution to the initial question of the thread.
>>>Yes, that's true. But I have LOCATE command after COUNT is done, so everything seems to be OK.
>>
>>If you would add an index to the cursor or table in the bottom grid, you could use SET KEY TO instead of SET FILTER for the best speed. If the cursor is at EOF in the bottom grid, there are no matching records to validate.
>
>I need to filter based on combination of two integer fields. I think I did consider SET KEY originally when I designed the form, but at the end decided otherwise and used SET FILTER. Since it's working and in production, I don't want to do a major overhaul.

No excuses. You can convert two integers into strings and index on that. It's no major overhaul.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform