Albert: Disconnect/reconnect did the trick.
Thank you Bruce -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Albert Berry Sent: Monday, July 08, 2013 2:52 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: DROP TABLE Confusion Bruce, disconnect everyone from the database. Disconnect yourself and reconnect. Look for the table. It might have been created as a permanent table somewhere else. Albert On 08/07/2013 3:40 PM, Bruce A. Chitiea wrote: > oops. nope. the table has NOT been dropped. The subsequent code simply > appends records to the original, undropped table. > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of Bruce A. > Chitiea > Sent: Monday, July 08, 2013 2:38 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - DROP TABLE Confusion > > All: > > 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 Chitiea > SafeSectors, Inc. > eCondoMetrics > 909.238.9012 cell > > > > > ----- > No virus found in this message. > Checked by AVG - www.avg.com > Version: 2013.0.3349 / Virus Database: 3204/6473 - Release Date: > 07/08/13 > >
