> Is it possible to query the database to see if it's 2.x or 3.x, we need to > know if the rowid's are 32 or 64 bit and we don't know what version we > might be running on?
You can check the DB file header. The first 16 characters are "SQLite format 3\000" if it is version 3+ Check out http://www.sqlite.org/cvstrac/getfile/sqlite/src/btree.c for more file header information This reminds me of a related point I ment to ask about Is it possible to determine what the version number of the DLL (Windows) is? The DLL doesn't seem to contain any version information
