Since temp tables can be "seen" only by the current user, there's no difference
whether there's 1 or 100 users.
But if you want to drop the table and then recreate it each time (which I
suggest) just do a simple
drop table tablename
As long as you have error messages turned off (or specifically error message
2038) no one will see the error message if the table doesn't exist
Karen
-----Original Message-----
From: Jim Belisle <[email protected]>
To: RBASE-L Mailing List <[email protected]>
Sent: Tue, Feb 10, 2015 5:08 pm
Subject: [RBASE-L] - speed
I appreciate the responses I got about using temp tables for my lookups.
Now since I have multiple users, I will need in the code to check if the temp
table is already made.
What code would I use for that?
The temp table name is tqts.
James Belisle
Making Information Systems People Friendly Since 1990
[cid:[email protected]]
