Hello, I am a little bit confused about the sqlite db version numbers. 1. On Windows 7 I have created a new db with command sqlite3.exe test.db3 The sqlite3.exe is from date 2013-05-20 and the version number shows 3.7.17
2. Same computer but now I create a db with sqlite3.exe from 2016-09-12 sqlite3.exe test1.db3 The version number now shows 3.14.2 3. I open both db (test.db3 and test1.db3) with sqlitestudio 3.0.6 and do a: Select sqlite_version(), Now for both dbs the version number shows 3.8.10 So from what depends the version number? From the tool or program which opens the db? If I create a new db like in step 2 where I have version 3.14.2 and I open it with an old tool or program, then I cannot use the newer functions and fixes of the new version? Can someone please give me a little bit clearness? thanks Werner _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users