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
