Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Difference between Single user Grid and Multiuser grid
Message
De
02/02/2007 12:17:41
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 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01190788
Message ID:
01191857
Vues:
19
>Perhaps. The other issue with filters and grids is the scroll bar does not work as it should. I use parameterized views. IMHO, it's a much more sublime solution.

Depends on the view and the parameters: http://msvfp.advisorguide.com/doc/16302

SPT with dynamically constructed ad-hoc parameterized where clauses is IMO the ultimate in control for me as a developer, flexibility for the user, performance and safety.

>
>>VFP 9 Help says following:
>>"When using SET FILTER to filter data in a grid, use the SET KEY command to increase grid performance."
>>Does it indicate that performance problem still exists?
>>
>>>I haven't used filters for a table of any significant size in ages. Love those parameterized views. However, I could swear that I recently came across something that was saying that in VFP 9 (or whatever it said - a recent version) the filters were now very fast and this made them useable again. Wish I could remember where I saw that (or perhaps I was hallucinating). Have you heard anything like that (I guess not based on your reply).
>>>
>>>>Then this is your problem. Grids and filters don't agree with each other. In fact, SET FILTER command is obsolete and should not be used at all. Look into parameterized view or CA solutions instead.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform