Wow, that sounds like a problem to me. One should not be able to alter permanent tables with STATICDB ON. The whole idea of STATICDB is to prevent structure modification while the databse is in use.
Dennis McGrath --- Dennis Fleming <[EMAIL PROTECTED]> wrote: > Emmitt, > (Just getting back to this thread) > > You mentioned: > "Just one word of advice - run with STATICDB ON." > > With Staticdb ON, I can't go into Table Definitions, but I can add a > column > to a table: Alt Tab XXX add Column ... > > What is the reasoning/pitfalls behind Staticdb ON/OFF > > TIA, > > Dennis > ***** > > > At 03:11 PM 7/18/2003 -0400, you wrote: > >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] > > > > > > > Dennis Fleming > IISCO > http://www.TheBestCMMS.com > Phone: 570 775-7593 > Fax: 570 775-9797 >
