>When I use the following code to change de rowsource property of a combobox
>vfp8 refuses to save it. (command contains unrecognised phrase/keywords)
>
>thisform.mycombo.rowsource = "select pr.descr as descr, pr.id_priority as idpriority ;
>from priority as pr, person as perso, prior_pers as prpers ;
>where pr.id_priority = prpers.id_priority ;
>and prpers.id_person = perso.id_person ;
>and perso.name = oapp.cuserid into cursor myCursor nofilter"
>
>I've executed the query in command window with succes.
>
>Yesterday it worked fine for another combobox. Now this first combobox gives the same error.
>I think the problem lies in the 'into cursor' part, when I leave this part out it works.
>But why this 'into cursor' part didn't create a problem yesterday ....
>
>Any help is much apreciated
>
>Victor
thisform.mycombo.rowsource = ;
"select pr.descr as descr, pr.id_priority as idpriority"+ ;
" from priority as pr, "+;
" person as perso, "+;
" prior_pers as prpers"+;
"where pr.id_priority = prpers.id_priority"+ ;
" and prpers.id_person = perso.id_person"+ ;
" and perso.name = oapp.cuserid into cursor myCursor nofilter"
A literal string cannot exceed 255 bytes.
Cetin