.... Local lcVariable lcVariable = ALLTRIM(STR(INT(VAL(Thisform.cboWc.Value)))) SELECT DISTINCT P.pj_pcode,P.pj_title,P.pj_state,P.pj_id ; FROM DD_Proj P, DD_Tasklist T, DD_Tskdwgs D ; WHERE P.pj_state='A' ; AND P.pj_id = T.tl_projid ; AND T.tl_id = D.td_tlid ; AND D.td_code = lcvariable ; ORDER BY P.pj_pcode ; INTO CURSOR ProjListNew ...But I guess you knew that! :-)
>... >SELECT DISTINCT P.pj_pcode,P.pj_title,P.pj_state,P.pj_id ; >FROM DD_Proj P, DD_Tasklist T, DD_Tskdwgs D ; >WHERE P.pj_state='A' ; >AND P.pj_id = T.tl_projid ; >AND T.tl_id = D.td_tlid ; >AND D.td_code = ALLTRIM(STR(INT(VAL(Thisform.cboWc.Value)))) ; >ORDER BY P.pj_pcode ; >INTO CURSOR ProjListNew >... >