>There is no file called "#SubFile" to be found. Object does not exist.
>
>I need a temp table that can be created at the start of an individual test that will remain 'alive' until the end of that test session. A test session will contain anywhere from 20 - 160 individual tests.
>
>What's the best way to do this?
>
>
>>The temp table created in the SP can only be visible by that SP or procedures called from that SP. So, what do you mean by temp table not created?
You need to create that table using a direct SQL statement sent from VFP. Then everything else that runs after that in that same session will have access to that table. Stored procedures run in their own sessions, so the temp tables created in them will be visible to these stored procedures (and everything that is called from them) only.
If it's not broken, fix it until it is.
My Blog