Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Listbox value not visible when Listbox gets focus
Message
 
To
01/06/2005 11:47:58
General information
Forum:
Visual FoxPro
Category:
Classes - VCX
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01018965
Message ID:
01019030
Views:
23
This message has been marked as the solution to the initial question of the thread.
It is good to see that article Sergey's poit to.
But for your needs try:
** In ListBox Properties
RowSourceType = 3 && SQL-Statement
RowSource = "SELECT Workshops.WorkshopName,WorkshopId FROM Workshops INTO CURSOR crsWorkshops"
BoundTo = .t.       && seems to be the only way to set it with int values
BoundColumn = 2
But keep in mind that if somhere else you changed the records in Workshops table (DELETE, UPDATE or INSERT) these changes will not affect the ListBox Itmes. You must issue:

thisform.Grid.ColumnX.ListBox.Requery() to make changes available.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform