[RBASE-L] - Re: Should cursors always be droppedbeforecreating them?

[A. Razzak Memon]

At 08:39 PM 11/8/2009, Michael J. Sinclair wrote:

Will that work for temporary tables?

For Temporary Table:

SET VAR vRows INTEGER = 0
SELECT COUNT(*) INTO vRows INDIC ivRows FROM SYS_TABLES +
WHERE SYS_TABLE_NAME = 'tablename' +
AND SYS_TABLE_TYPE = 'TABLE' +
AND SYS_TEMPORARY = 1

IF vRows = 0 THEN
   -- Do what you have to do ..
ELSE
   -- Do what you have to do ..
ENDIF
CLEAR VARIABLES iv%,vRows
RETURN

You may also try the following technique if you always
need to create a fresh temporary table.

SET ERROR MESSAGE 2038 OFF
DROP TABLE tTableName
SET ERROR MESSAGE 2038 ON
CREATE TEMPORARY TABLE `tTableName` +
(`Column1` TEXT (31), +
 `Column2` TEXT (31), +
 `Column3` NUMERIC (6,0), +
 `Column4` DATE, +
 `Column5` TIME)
COMMENT ON TABLE tTableName IS +
'Temporary Table ...'
RETURN

Very Best R:egards,

Razzak.