Hi, Most of our multi-user databases are also connected to internet via the Oterro odbc using RTango2000. I think it is a combination of the two that is causing the problem. Instead of spending the time at the moment to research the error, I just went with permanent tables and run a maintenance routine to backup and pack the database. I would like to be using temp table so when I find the answer I will let you know.
Ted -----Original Message----- From: Ben Petersen [mailto:[EMAIL PROTECTED] Sent: Monday, July 21, 2003 12:15 PM To: [EMAIL PROTECTED] Subject: [RBASE-L] - Re: Temp Views/Table Ted, Do you experience this error when creating temp tables in multi-user environments? I'm just now finishing a large app that makes heavy use of temp views and a few temp tables. If there is a gotcha waiting in the wings I'd appreciate a heads up. Thanks, Ben Petersen On 21 Jul 2003, at 8:29, Ted Wolfley wrote: > 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] >
