Bruce, I would move the DROP CURSOR c1 command to just after setting the error messages off. The reason to do this is that the CURSOR might use some of the tables you are attempting to drop. If a table is part of a CURSOR a DROP TABLE command will fail in the CURSOR is still defined.
Jim Bentley, American Celiac Society 1-504-737-3293 ________________________________ From: Bruce A. Chitiea <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Monday, July 8, 2013 5:09 PM Subject: [RBASE-L] - Re: DROP TABLE Confusion 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! --
