Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sorting a 1 to Many Grid by one of its columns?
Message
De
22/04/2001 07:43:05
 
 
À
21/04/2001 11:04:45
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00498259
Message ID:
00498362
Vues:
19
Hi Mike.

>> When the grid displays the employees for that corporation, I would like to sort the Grid's displayed records by position (the 4th column).

LinkMaster is Corp
RelationalExpr is CCorp_Key
Child Order is (None) <<

The easy answer here is to set up a parameterized view for the employees. This view is simple enough that even the view designer can handle it. Under the filter tab in the view designer, you specify the parameter for the view like so:

Corp.cCorpKey = ?vp_cCorpKey

Specify the order for your parameterized view to be by employee.position

You can add your parameterized view (suppose it is called lv_Employees) to the DE in the form just like you would any table. Just make sure to set the view's NoDataOnLoad property to true. Otherwise, you will get an annoying prompt for the view parameter when your DE loads.

Then, in the AfterRowColChange of the parent grid, you put code like this

vp_cCorpKey = Corp.cCorpKey
REQUERY( 'lv_Employees' )

Marcia
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform