We sometimes see "Waiting for access to required resource" errors, but I cannot specifically relate that to creating temporary tables.
Hi,
Just wondering, do you ever get the Multi-User error that resources are unavailable when trying to create temp tables?
Ted
-----Original Message----- From: Emmitt Dove [mailto:[EMAIL PROTECTED] Sent: Friday, July 18, 2003 3:12 PM To: [EMAIL PROTECTED] Subject: [RBASE-L] - Re: Temp Views/Table
Dennis,
The beauty of a temporary table or view is that it is specific to the user. So five different users can all create the same temporary table with the same name and not interfere with the others. Therefore, the drop before create should only affect the user running the program. I always drop after I am finished with the table or view.
Just one word of advice - run with STATICDB ON.
>RBase 6.5++ > >In the process of converting lots of tables/views to Create Temp >tables/views. But, since this is a multi user app, only time I >disconnect (and they are >deleted) is when they load a program update or Reload their data base. > >So, I have Drop view/table before (and after?) each code segment that >creates them. If a second user comes along and tries to run the same >piece of code before the first users exits... it works just fine. I >didn't realize the temp tables/views are saved with each user and you >don't have to worry about duplicate table/view names. > >But, what about deleting them before/after the code is run? > >TIA, > >Dennis >***** >Dennis Fleming >IISCO >http://www.TheBestCMMS.com >Phone: 570 775-7593 >Fax: 570 775-9797
Emmitt Dove Manager, DairyPak Business Systems Blue Ridge Paper Products, Inc. 40 Lindeman Drive Trumbull, CT 06611 (203) 673-2231 [EMAIL PROTECTED] [EMAIL PROTECTED]
Emmitt Dove Manager, DairyPak Business Systems Blue Ridge Paper Products, Inc. 40 Lindeman Drive Trumbull, CT 06611 (203) 673-2231 [EMAIL PROTECTED] [EMAIL PROTECTED]
