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? Thanks! Rick -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Rick Ratchford Sent: Wednesday, July 01, 2009 7:06 PM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] Changing Table Contents DROP TABLE Foo; -- It's okay to execute this command, even if Foo does not exist already. Hello David. Thanks for your reply. The above "Drop Table" created an error when I tried to run it when no table existed. CREATE TABLE Foo ( ... ); Forgive my novice ignorance. Although I have no trouble executing this SQL without an error, where do I look for the return value? I'm using a VB wrapper, and so I run this by... Cnn.Execute "Select count(*) FROM sqlite_master WHERE tbl_name = 'DeltaGrid'" Thing is, I don't know where to check for the return value. Thank you. Rick _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
