This is strange because I actually had "if exists" in my code: sqlKWDrop = 'DROP TABLE IF EXISTS ' + kwTable + ';'
where kwTable, in the instance cited below, becomes "judaism_128". What gives? Victor On Sun, Aug 9, 2009 at 7:57 PM, Dennis Lee Bieber <wlfr...@ix.netcom.com>wrote: > On Sun, 9 Aug 2009 15:21:43 -0500, Victor Subervi > <victorsube...@gmail.com> declaimed the following in > gmane.comp.python.general: > > > Hi: > > I get a ton of warnings like this from a program I run: > > > > Warning (from warnings module): > > File "C:\Python25\read.py", line 67 > > cursor.execute(sqlKWDrop) > > Warning: Unknown table 'judaism_128' > > > Personally -- I'd suggest fixing the database so that the table > does > exist... > > Ah, but then -- it appears from the name, that the purpose of this > SQL statement is to delete the table... In which case use a database > that supports (for example, current versions of MySQL, SQLite, and > PostgreSQL) "drop table IF EXISTS tbl_name" which suppress the > warning/error message and update the SQL as appropriate. > > Appears that M$ SQL Server does NOT implement that syntax... Nor > could I find it for Firebird. > > If the application is specific for one database engine, it might be > worth it to find out what features permit discovering if a table exists > and bypassing the drop if it doesn't... > > > -- > Wulfraed Dennis Lee Bieber KD6MOG > wlfr...@ix.netcom.com HTTP://wlfraed.home.netcom.com/ > > -- > http://mail.python.org/mailman/listinfo/python-list >
-- http://mail.python.org/mailman/listinfo/python-list
