Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Help with p-views
Message
De
23/09/2004 21:40:50
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
23/09/2004 20:57:02
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00945595
Message ID:
00945598
Vues:
21
>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)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform