Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to keep Grid contents sorted on RecordSource field
Message
De
21/05/2003 11:13:24
 
 
À
21/05/2003 08:57:25
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00790972
Message ID:
00791099
Vues:
28
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform