Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combobox display question
Message
 
To
01/06/2001 12:22:19
David Fluker
NGIT - Centers For Disease Control
Decatur, Georgia, United States
General information
Forum:
Visual FoxPro
Category:
FoxPro 2.x
Miscellaneous
Thread ID:
00513150
Message ID:
00513915
Views:
14
OK I will see how simple I can make it

>>Hello Everybody
>>
>>I have a short question
>>
>>in foxpro2.6x (dos) can I display more then one field in a dropdown combobox
>>
>>like vendor and vendor_id in the dropdown part, I don't care if the inactive dropdown box only shows one field, as long as the activate (opened) dropdown box shows more then one field
>>
>>list in visual foxpro all you have to say is columncount = 2, ya know??????
>>
>>Thanks
>
>
>Steve,
>FoxPro for DOS doesn't directly support popups lists (FPD's @GET version of a combobox) based on fields in a table. It allows you type in values or base it on an array. You can create an SQL statement to load the array.
>
SELECT Vendor + " - " + Vender_ID AS PopVar FROM Vendors INTO ARRAY arPop
>Then base your popup list on arPop.
>
>You _can_ base a list box or a Popup (Using DEFINE POPUP) on fields in a table. To use multiple fields, put Vendors.Vendor_ID + " - " + Vendors.Vendor in the field box. The list will show both fields. You can use this method to show as many fields as will fit.
>
>You can pull out one field with a LEFT, RIGHT, or SUBSTR.
>
>Final note. We used to simulate a combo box in DOS with a text field and a button. The button would ACTIVATE a POPUP just below the text field. Worked pretty well.
Stephen McLaughlin
"Sexy Steve Valenteno", "Blastmaster"
stephenmclaughlin@gmail.com
Previous
Reply
Map
View

Click here to load this message in the networking platform