Zlatin,

Thanks for your reply. The INCLUDED database works fine as a seperate EXE so we're going to leave it that way.

Will

>>Any ideas how to make FoxPro NOT use the INCLUDED table in a SQL Select?
>
>Have not found way (I think there is no such way - this is one of the reasons we do not use included databases in our application)
>Instead we ship our exe with a data-dictionary and recreate the databases/tables if needed from the data-dictionary. Also for demonstration purposes we ship external tables/DBCs with our executables.
>
>
>>BTW, the INCLUDED database is closed when executing the SQL against the EXCLUDED table.
>
>Really? Have you checked what DBUSED('IncludedDataBase') returns after calling CLOSE DATABASES ALL and IncludedDataBase is a database that is included in your executable? In VFP6 SP1-SP5 and in VFP7 SP1 it returns .T. nevertheless CLOSE DATABASES ALL is executed
>
>Kind Regards