I use this (where in this case invt is the name of the temp table): set var vIsItThere int=0 SELECT COUNT(*) INTO vIsItThere IND vI1 FROM SYS_TABLES WHERE SYS_TABLE_NAME = 'invt' IF vIsItThere = 0 THEN project temporary invt from inv using all where limit=0 else del rows from invt endif
Bernie Lis ----- Original Message ----- From: jan johansen To: RBASE-L Mailing List Sent: Monday, February 23, 2009 4:17 PM Subject: [RBASE-L] - Temp tables Group, What is the best way to check for the existance of a temporary table? Jan
