>Hi All:
> I am trying to populate my list view at run time with the my sql statement. However, when this line of code is executed, I get an error message "Command contains unrecognized phrase\keyword". Can any help me with the problem and tell me what am I doing wrong.
>
>Thanks
>
>.LstSource.RowSource = ; && List view
> "SELECT &gcSelect FROM shSrce WHERE UPPER(fcShipNo)+UPPER (fcItemNo)+UPPER(fcShipSrce)+UPPER(fcSrcItmNo)=upper(ctemp.fShipNo)+UPPER(ctemp.fItemNo) INTO CURSOR csrShSrce ORDER BY KeyFld"
Mahmood,
If that's not a typo " && List view " comment would be after "...Order by keyfld"
.LstSource.RowSource = ;
"SELECT "+gcSelect+;
" FROM shSrce "+;
" WHERE UPPER(fcShipNo+fcItemNo+fcShipSrce+fcSrcItmNo) = "+;
" upper(ctemp.fShipNo+ctemp.fItemNo) "+;
" INTO CURSOR csrShSrce "+;
"ORDER BY KeyFld"
I hope fcShipNo, fcItemNo etc are not variables.
Cetin