On 25 Nov 2010, at 4:06pm, Tito Ciuro wrote: > Wouldn't be better to issue a SELECT statement and let SQLite come back with > a SQLITE_NOTADB error right away?
In one of my applications I used to do a SELECT on sqlite_master. This confirms that the file exists, that it's not blank, and that it was used as an SQLite3 database somewhere along the way and not, say, an SQLite2 database or a text file. It takes so little time you can include it in startup routines without people complaining. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users