Then my question is, how do you get around that error when you have automated processes that rely on temporary tables in a multi-user environment? Do you run a check to see if the temp table was created?
Ted -----Original Message----- From: Emmitt Dove [mailto:[EMAIL PROTECTED] Sent: Monday, July 21, 2003 8:20 AM To: [EMAIL PROTECTED] Subject: [RBASE-L] - Re: Temp Views/Table 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]
