Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL-Select says: Table does not exist
Message
 
 
To
09/06/2009 16:43:26
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01404674
Message ID:
01404867
Views:
47
>>Hoi peter,
>>
>>This behaviour also exists with classes in classlibs. If you execute a script with EXECSCRIPT(), it can't find any classes in the executable if not already loaded.
>>
>>The trick I used is to have a DOCMD() function in the exe, so you can can call DOCMD([x=CREATEOBJECT("Myclass")]). This is because from the script I go back into the executable through the DOCMD() function. Of course the DOCMD function is very simple like
>>
>>
FUNCTION Docmd(cCommand)
>>&cCommand
>>RETURN
>>
>>So your problem can be solved if you've got a DOCMD() function in your startup prg, and call:
>>
DOCMD("select * from tableX into cursor whatever")
>
>Another trick you can do this way is to
>
>
private param1, param2, pcScript, plRet
>* assignments to  these variables, then
>docmd("plRet=execscript(pcScript, param1, param2)")
>
>This way you aren't limited to running a single command.

No, you cannot. The EXECSCRIPT() will run the code as external prg which will cause the same problem as in original post
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform