Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Filtering a local view.
Message
 
 
To
26/09/2000 10:17:10
John Vlahos
V I Software Solutions Design
Mississauga, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00420901
Message ID:
00420914
Views:
22
If the view is parameterized, just set the appropriate variables and issue a Requery() when they want to apply the new filter. Then refresh the grid. That should do it.

You can use the SET FILTER command but it will be a lot slower when the user is navigating the grid.

>Hi Everyone:
>
>I have a grid which contains all the shipping addresses pertaining to a specific customer.
>
>I would like the user upon viewing all the shipping addresses be able to filter the view as the user wishes.
>
>At this moment I grab all the criteria into text fields to perform the serach/filter to the local view, but how may I apply this criteria to the current view, within the same grid?
>
>I would like to be able to filter upon filter upon filter.....within the same grid.
>
>Do I need to se the SET FILTER TO command, or is there a way I may REQUERY() the local view to show the desired information?
>
>Thanks in advance!
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform