Ah yes! Temp tables are different. I do drop it when the form closes so that will care for my concerns.
James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]] From: [email protected] [mailto:[email protected]] On Behalf Of Karen Tellef Sent: Tuesday, February 10, 2015 5:14 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: speed 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]<mailto:[email protected]>> To: RBASE-L Mailing List <[email protected]<mailto:[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]<mailto:[email protected]>]
