Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Displaying on Forms
Message
 
To
14/05/1999 15:07:26
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00219178
Message ID:
00219180
Views:
22
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform