>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,
Hi Walter,
and this ?
USE MyInternalTable
MESSAGEBOX(SET("Datasession"))
EXECSCRIPT([MESSAGEBOX(SET("Datasession"))])
EXECSCRIPT("MESSAGEBOX(USED('MyInternalTable'))")