Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot access the selected table Error message ?
Message
 
To
12/02/2004 09:47:23
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00876612
Message ID:
00876679
Views:
11
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
...
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform