Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BUG2: SQL SELECT does not see open alias
Message
From
01/04/2005 12:56:48
Walter Meester
HoogkarspelNetherlands
 
 
To
01/04/2005 08:47:29
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01000541
Message ID:
01000739
Views:
28
>>In VFP8 I could do the following with a table included into the exe (thus not available on disk).
>>
>>
USE MyInternalTable
>>EXECSCRIPT("SELECT * FROM MyInternalTable")
>>
>>In VFP9 this does not work anymore. VFP9's SQL SELECT simply does not see the open alias and attempts to open it from disk.
>>
>>Walter,
>
>this ?(We are scrambling up on the mirrors)?
>
>USE MyInternalTable
>EXECSCRIPT("SYS(2450,1)"+CHR(13)+CHR(10)+"SELECT * FROM MyInternalTable")
>
Nope same problem. Does not work...

Walter,
Previous
Reply
Map
View

Click here to load this message in the networking platform