On 2 Jul 2009, at 1:22am, Rick Ratchford wrote: > Okay, I found what needed to be added to DROP TABLE to make it not > produce > the error. > > DROP TABLE IF EXISTS Foo > > That did the trick. > > Still haven't figured out how to get the test result from... > > SELECT count(*) FROM sqlite_master WHERE tbl_name = 'Foo'; > > If this returns 1 or 0 based on whether there is a table called > 'Foo' in the > sqlite_master, where does one check for that 1 or 0?
You no longer care. Each time you want to start again do these two commands: DROP TABLE IF EXISTS foo; CREATE TABLE foo ... (whatever your requirements are) Neither will give an error. The second command will always result in an empty table. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
