Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Special Ordering of Items in child table - twisting my b
Message
 
À
08/12/2003 02:36:24
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00856757
Message ID:
00856760
Vues:
15
Why instead of OrderNo You just not set a Field family member type:
1 - father
2 - mather
3 -grand.. etc in order which you want .
The Just by a simple SELECT You can order the cursor.
SELECT Child_Table.*,  Parent_Table.[what you want],;
       IIF(INLIST(Child_Table.FamilyType,1,2...),.t.,.f.) AS Bolded;
 FROM Child_Table;
       LEFT JOIN Parent_Table ON Child_Table.Family_no == Parent_Table.Family_no;
ORDER BY Child_Table.Famili_No, Child_Table..FamilyType;
INTO CURSOR PrtCursor
HTH (If I understand you right)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform