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!
--
