Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SET FILTER Command
Message
From
24/05/2002 11:47:16
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
24/05/2002 11:36:33
Roman Segaud
Laboratoires Fortepharma
Nice, France
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00660922
Message ID:
00661098
Views:
50
>You're quite right, but the grid is the fastest object i know to display data and combinated with a textbox for search it's a ergonomic way to provide data to users.
>
>Roman

Well, what I mean is that, AFAIK, a) A filtered grid is slow. b) A grid with a parameterized view is fast - unless the parameterized view fetches a lot of data for a specific key value. Which seems to be precisely your problem.

One possibility is to show the users all data that start with a certain letter(s) - using this as the view's parameter, or one of the parameters.

If the user types only a single letter (or none at all!) and then presses a "Show" button, he will have to put up with a longer loading time. That is, users should type at least one, better two or more, letters, most of the time.

Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform