Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help with p-views
Message
From
23/09/2004 21:40:50
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
23/09/2004 20:57:02
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00945595
Message ID:
00945598
Views:
22
>i have set filter on my grid. and, it's very slow. i know i have to use p-views, but i do not know exactly how to do it.
>
>can anyone guide me pls?
>
>TIA.

Define the view as usual.

Under filter, set a condition, similar to ParentKey = ?vParentKey

assuming that you want all records that match a certain record in a parent table, and that ParentKey is the linking field.

Put the view on the form's DataEnvironment. Set the view to not show data initially. I think that would be the NoDataOnLoad property.

You can also open the view in Form.Load(), with the NODATA clause.

Later, assign a value to the variable vParentKey, which you define as private, and requery the view.
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
Reply
Map
View

Click here to load this message in the networking platform