.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.Refreshbut it is not displaying the new values inside the combobox, how can solve this?