Thanks to everyone for responding. I had turned off email delivery a few months ago but forgot to turn it back on when I got back to working with Sqlite again. Thanks Peter. I guess this means there is really nothing in my code that needs to change other than replacing the explicit database name in sqlite3_open with empty quotes. Unlike what I said in my original post I'd rather use the temporary DB approach than a pure in-memory solution.
On Thu, Nov 24, 2011 at 8:45 AM, Dilip Ranganathan <[email protected]>wrote: > Currently I use sqlite to create a bunch of on-disk tables to store my > data. I use Sqlite's master table to determine if a table already exists > based on which I take certain decisions. > > Suppose I switch these to in-memory tables (:memory:), how do I go about > checking if a table exists? Do in-memory tables still get an entry in the > master table? If not, how else should I go about with this? > > thanks! > > P.S: I know that one can simply do a CREATE TABLE IF NOT EXISTS... but I > still need to know if a table exists or not. > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
