Tim,
You are correct, the problem I've been running into are those "dynamically numbered" temp tables created automatically by DBISAM which are out of my
control.
Rick

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

Jon,

<< but doesn't

 "select ..... into memory\tmp... "

get around the problem?  You have to remember that you created an in memory
table of course. >>

For queries, yes, you are correct.  I was under the impression that his
issue was *all* temporary tables, but that may just be down to my shoddy
reading comprehension since I'm speed reading these messages every day.

--
Tim Young
Elevate Software
www.elevatesoft.com

Rick,

<< You are correct, the problem I've been running into are those
"dynamically numbered" temp tables created automatically by DBISAM which are
out of my control. >>

Yes, but those can be created by either table alterations, optimize, etc. or
they can be created by queries.  If you're not doing any table alterations,
etc. then the temporary tables are being created by queries, and the
suggestion that Jon gave would work in that case.

--
Tim Young
Elevate Software
www.elevatesoft.com