On 20 Jun 2012, at 4:43pm, Maury Markowitz <maury.markow...@gmail.com> wrote:
> So can anyone suggest any SQLite command I might send in through the SQL > interface that should return something even if there is no active DB > connection? Your interface may do its own checking for a DB and refuse to process a SQLite command without it. But you should be able to do either or both of the following commands SELECT sqlite_version() PRAGMA database_list which will both return tables, like a SELECT command would. By the way, if you want to check out that you really do have a working database file, there's a SQLite utility called the 'sqlite command line shell' which is fully supported by the SQLite team. Download a version from here <http://www.sqlite.org/download.html> and the documentation is here <http://www.sqlite.org/sqlite.html> . If that shell tool can open your database and you can do a '.tables' on it and see the right tables, then the database file is definitely there, and in the folder you think it's in. If the shell tool can't see the tables in your database then there's no point in trying anything else until you've figured out what's wrong. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
