Hi all

I have been asking help from all of you regarding temp tables, here is another one.

UPDATE: I have created them with single # not ##

What is a session and the scope of the session in VFP terms. I have a bit of code that is creating temp tables, there is a point in it where it errors, but the app is definately running as the error is handled. Now I try to goto Query Analyser and try to check out the erroring part of SQL statement, hoping that the other successfully created temp tables will be available for testing purposes, but they are not.

- Are they gone because the prg ended (not the app it is still running)?
- Or VFP has it's own session and Query Analyser it own?
- Error or not, will temp tables go away as soon as the prg / form / class which created it goes out of VFP scope?
- Will the temp tables stay until the app exits?

Please advise.