Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot access the selected table Error message ?
Message
From
12/02/2004 11:13:57
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00876612
Message ID:
00876695
Views:
9
Hi Borislav,

To be able to use Rusmore, you must change this a little bit:
>
....
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! :-)

>Change the valid method like this:
>
>...
>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
>...
>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform