Hi, Peter, On Fri, Jul 21, 2017 at 11:06 AM, Peter Da Silva <peter.dasi...@flightaware.com> wrote: > https://www.sqlite.org/c3ref/c_source_id.html
Those are for the library. But... Let's say I made some database files 2 years ago. Now I want the current SQLite code to open them and performs some queries from the C interface. > > This is also stored at offset 96 in the db file: > > https://www.sqlite.org/fileformat.html Is this the number I'm after? Thank you. > > I don’t think there’s a pragma for extracting it from within SQLite code. > > On 7/21/17, 9:58 AM, "sqlite-users on behalf of Igor Korot" > <sqlite-users-boun...@mailinglists.sqlite.org on behalf of > ikoro...@gmail.com> wrote: > > Hi, ALL, > Is there a way to know the version of the .db file I am using? > > I'd like to issue some kind of SELECT statement to get it. > > Looks like there is an interface to get the library version, but I don't > see anything for a db file. > > Thank you. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users