Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parameters in Load events
Message
 
To
16/12/1999 16:47:25
Alvin Potot
Rhine Marketing Corporation
Cebu, Philippines
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00304890
Message ID:
00304959
Views:
28
>I need to filter records (used by a grid control) based on the passed parameter values!

Alvin,

First you can pass your parameter and SET FILTER TO ... in teh fomr's inti tnad then refresh the grid. However, you should know that filters and grids are not good bedfellows. A grid does some really slow management of filtered recordsources that negate the benefits of Rushmore totally.

You really should use a parameterized view. Yes, you are right views must be defined in a databse, but the source table for a view can be anywhere.

So you create a database, create your view in the database but make the source tables your free tables. Your view cna be parameterized and it can also be updatable.

PLace your view in the Data environment of the form with the NoDataOnLoad property set .T. and then in the form's Init you can set the parameter variables and ReQuery("TheView").
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform