Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sorting the grid
Message
 
À
15/05/2001 10:50:46
Chuck Tripi
University of Wisconsin - Milwaukee
Milwaukee, Wisconsin, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00507310
Message ID:
00507640
Vues:
16
Chuck,
If you are using the internal grid functionality to show child records (LinkMaster, ChildOrder, etc.) then the index for each sort order must contain the key used in ChildOrder as well as the information for ordering individual items (date, description etc.).

So if the foreign key linking the child table to the parent table is called "ParentID" and you want to order the child records by a "LastName" field, then you'd need an index on ParentID+LastName. Of course you'll need to make sure each field is the same type - usually all character works best since you can translate integer or date into character easily.

If the index on the child table does not contain the foreign key field then your grid will unlink itself from the parent table.

HTH
Barbara

>I have a form with all working operations. Now I need to sort the grid (Column2), how to do that? I have the Grid1.ChildOrder: main, but I couldn't find where to sort the grid (another step beyond?)?
>
>Chuck
Barbara Paltiel, Paltiel Inc.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform