Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Displaying on Forms
Message
 
À
14/05/1999 15:07:26
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00219178
Message ID:
00219180
Vues:
23
>Situation: I have a tabled called BAYLOR. The fields within this table are CDC_ID(c), EXP_ID(C)There are five (5) records with the CDC_ID 557-5555-88888. Each record has different EXP_IDs. I need to be able to display all EXP_IDs that pertain to that particular CDC_ID on a form.
>
>How can I?

There are a bunch of different ways to do this. You could create a view that filtered this info. Or you could just use a SELECT command to build a cursor with those records. The SELECT would look like:
vp_Filter = "557-5555-88888"

SELECT EXP_ID;
   FROM BAYLOR;
   WHERE BAYLOR.CDC_ID = ?vp_Filter;
   INTO CURSOR v_Baylor
Now you can bind this cursor into a ListView, grid, etc.
-Paul

RCS Solutions, Inc.
Blog
Twitter
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform