Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Change the RowSource to a combobox
Message
De
23/05/2007 15:26:53
 
 
À
23/05/2007 15:23:07
Information générale
Forum:
Visual FoxPro
Catégorie:
Programmation Orientée Object
Divers
Thread ID:
01228029
Message ID:
01228031
Vues:
17
>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?

Combobox.Requery after you change rowsource.
Edward Pikman
Independent Consultant
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform