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
