Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to keep Grid contents sorted on RecordSource field
Message
From
21/05/2003 11:13:24
 
 
To
21/05/2003 08:57:25
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00790972
Message ID:
00791099
Views:
29
Cetin,

Sorry to say, but your solution did not work; when I changed ChildOrder back to rd_rcn it worked showing child table data in grid (albeit, not correct for Grid displayed rows sort order).

When I used your concatenated - 2 field - string index tax from RecordSource (Child table) nothing displayed in Grid.

Here is implementation of your Solution that did not work.

Tables:

Parent (dd_Ear)
Field: ar_rcn (Integer)
Index (tag): ar_rcn (Field ar_rcn)

Child (dd_Earappdwg)
Fields: rd_rcn (Integer), rd_dsort (Char)
Index (tags):
rd_rcn (Field rd_rcn), rd_grdsort (Expr: Str(rd_rcn)+Alltrim(rd_dsort))

DD_ear:
Form (with Grid) Load() method:
USE DD_ear order rd_rcn share
USE DD_earappdwg order rd_rcn share
SET RELATION TO ar_rcn INTO dd_earappdwg IN dd_ear ADDITIVE

Form Grid Properties:
ChildOrder: rd_grdsort
LinkMaster: dd_ear
RecordSource: dd_earappdwg
RelationalExpr: str(ar_rcn)

Through Form (.SCX) I have function to add records to child table (dd_earappdwg). That is when child records should freshly
display in Grid (existing child records are displayed in grid when parent table that links them is pointed to via navigation in Form).

Fred Z
Don
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform