[RBASE-L] - DROP TABLE Confusion

[Bruce A. Chitiea]

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