Temporary tables and views are unique to each user. I usually just drop
the table (with error message 2038 off) as for example:
SET ERROR MESSAGE 2038 OFF
DROP TABLE xyz
SET ERROR MESSAGE 2038 ON
Albert
On 2/10/2015 4:08 PM, Jim Belisle wrote:
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]]
--
A democracy ..." can only exist until the majority discovers it can vote itself
largess out of the public treasury."
Attributed to Alexander Fraser Tytler 1747-1813
