SET ERROR MESSAGE 2038 OFF DROP TAB TableName SET ERROR MESSAGE 2038 ON CREATE TEMPORARY TABLE `TableName`
OR SET ERROR MESSAGE 2038 OFF DROP TAB TableName SET ERROR MESSAGE 2038 ON PROJECT TEMP tTableName From TableName USING * WHERE LIMIT = 0 Victor Timmons Tiz's Door Sales, Inc Visit us at www.tizdoors.com P Please consider the environment before printing this e-mail -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Albert Berry Sent: Monday, July 12, 2010 8:15 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: How do I tell if a temporary table exists? Karen is right on with this. That's why I always drop the temp table and create a new instance. Albert [email protected] wrote: > Mike: There is no problem turning the error message off, and then > doing the create and letting it fail if it wants... But if it fails > then realize that that table might already have data in it! I'm > assuming that you would want to create an empty temp table, right? > If so then you for sure want to make sure that table is dropped and > recreated. > > Karen > > >> Thanks Mike! Question.... If method 1 is considered a "good >> technique", is there anything wrong with just turning the error >> messages off and creating the table even when it already exists? Is >> there any reason to think that would cause any problems like a memory >> leak or database corruption if that were done many times? Could it >> slow down the application? >> Mike >
