Thank you very much. In a fluid testing session, I established error message '380' in response to this error when dropping the temp table:
'Drop aborted, resource unavailable (380)' The actual error message stack looks like this: SET ERROR MESSAGE 2038 OFF SET ERROR MESSAGE 705 OFF SET ERROR MESSAGE 677 OFF SET ERROR MESSAGE 380 OFF SET ERROR MESSAGE 46 OFF DROP INDEX tt_glTree1 DROP INDEX tt_glTree2 DROP TABLE tt_glTree DROP VIEW tv_glLevel1 DROP VIEW tv_glLevel2 DROP VIEW tv_glLevel3 DROP VIEW tv_glLevel4 DROP CURSOR c1 SET ERROR MESSAGE 46 ON SET ERROR MESSAGE 380 ON SET ERROR MESSAGE 677 ON SET ERROR MESSAGE 705 ON SET ERROR MESSAGE 2038 ON Bruce -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Monday, July 08, 2013 2:53 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: DROP TABLE Confusion At 05:38 PM 7/8/2013, Bruce A. Chitiea wrote: >At the top of a routine, I drop a TEMP table: > >SET ERROR MESSAGE 380 OFF >DROP TABLE tt_glTree >SET ERROR MESSAGE 380 ON > >Later, when I attempt to create the table: > >CREATE TEMP TABLE tt_glTree + >(blah blah ....) > >... I receive the error message: > >'-ERROR- New table is a duplicate. (2758)' > >... and proceed to successfully create the table. > >I've verified that at the time of table creation, the DROPped table HAS >been dropped. Bruce, Actually, 2038 is the message number for TABLE and 677 for VIEW, when using suppressing the -ERROR- message. -- Example 01 SET ERROR MESSAGE 2038 OFF DROP TABLE tablename SET ERROR MESSAGE 2038 ON -- Example 02 SET ERROR MESSAGE 677 OFF DROP VIEW viewname SET ERROR MESSAGE 677 ON Very Best R:egards, Razzak. www.rbase.com www.facebook.com/rbase -- 30+ years of continuous innovation! 15 Years of R:BASE Technologies, Inc. making R:BASE what it is today! --
