> SELECT COUNT(*) INTO vCount FROM SYS_TABLES + > WHERE sys_table_name = '<name of temp view>' > IF vCount > 0 then > DROP VIEW <name of temp view> > ENDIF > CREATE TEMP VIEW ...
I do: SET ERROR MESSAGE 677 OFF DROP VIEW <name of temp view> SET ERROR MESSAGE 677 ON CREATE TEMP VIEW . . . -- Larry
