Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Change the RowSource to a combobox
Message
From
23/05/2007 15:23:07
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Object Oriented Programming
Title:
Change the RowSource to a combobox
Miscellaneous
Thread ID:
01228029
Message ID:
01228029
Views:
66
Hi, i have a query in a combobox this way:
.combo1.rowsourcetype = 3
.combo1.rowsource = SELECT cv.nombre, heritage.hijo, cv.genero FROM cv, heritage WHERE heritage.padre=cv.idn  into cursor "FOP"+substr(sys(2015),3,10)
but on execution mode i'd like to change it when user clicks on it to:
thisform.pageframe1.page1.combo1.RowSourceType = 3 
thisform.pageframe1.page1.combo1.RowSource = ;
"SELECT Cv.idn, Cv.nombre, Cv_a.nombre AS nombrepm, Cv_a.genero AS generopm " + ;
"FROM fc!cv RIGHT OUTER JOIN fc!cv Cv_a ON Cv.idn = Cv_a.padre " + ;
"WHERE Cv.idn = "+ALLTRIM(STR(m.mival2))+" AND Cv_a.genero = 'Caballo' " + ;
"INTO CURSOR padre" &&SYS(5)+CURDIR()+"queries\padre2.qpr" &&"SELECT cv.nombre FROM cv WHERE cv.padre = "+transform(m.mival)+" AND cv.genero = 'Caballo' into cursor padre"
thisform.pageframe1.page1.combo1.Requery
thisform.pageframe1.page1.combo1.Refresh 
but it is not displaying the new values inside the combobox, how can solve this?
Next
Reply
Map
View

Click here to load this message in the networking platform