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

Reply via email to