Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Difference between Single user Grid and Multiuser grid
Message
From
02/02/2007 12:17:41
Mike Yearwood
Toronto, Ontario, Canada
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01190788
Message ID:
01191857
Views:
18
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform