Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL-Select says: Table does not exist
Message
From
09/06/2009 16:43:26
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
09/06/2009 15:33:33
Walter Meester
HoogkarspelNetherlands
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:
01404861
Views:
43
>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.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform