>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)