Hi sergey,
>It looks like a bug in EXECSCRIPT() to me.
I'm not sure if it is. It looks like a bug in SQL-SELECT to me, since it now does not pickup the open alias anymore, but goes looking for the actual file given by the DBF() function.
That indeed would fail when the alias comes from an internal file and the SQL-SELECT runs externally from the exe.
Walter,
>>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.
>>