Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sorting the grid
Message
 
To
15/05/2001 10:50:46
Chuck Tripi
University of Wisconsin - Milwaukee
Milwaukee, Wisconsin, United States
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00507310
Message ID:
00507640
Views:
14
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.
Previous
Reply
Map
View

Click here to load this message in the networking platform