Page 1 of 1
Where do I find the version of SQLite used by PB?
Posted: Mon Dec 31, 2018 4:45 pm
by swhite
Hi
I have been searching for information about the version of SQLite included with PB. Does anyone know where to find this information? Similarly is they a way to find out the versions of other libraries included with PB. It would be nice if these versions where listed in the documentation with each release of PB.
Thanks,
Simon
Re: Where do I find the version of SQLite used by PB?
Posted: Mon Dec 31, 2018 4:58 pm
by spikey
The resulting column is a string in x.x.x format.
Re: Where do I find the version of SQLite used by PB?
Posted: Mon Dec 31, 2018 5:00 pm
by skywalk
Code: Select all
UseSQLiteDatabase()
dbn = OpenDatabase(#PB_Any, ":memory:", #Empty$, #Empty$, #PB_Database_SQLite)
DatabaseQuery(dbn, "Select sqlite_version();")
NextDatabaseRow(dbn)
Debug GetDatabaseString(dbn, 0)
FinishDatabaseQuery(dbn)
CloseDatabase(dbn)
Or more directly
Code: Select all
UseSQLiteDatabase()
ImportC "" ; UseSQLiteDatabase() must be called prior
sqlite3_libversion()
EndImport
Debug PeekS(sqlite3_libversion(), -1, #PB_Ascii)
EDIT: added ImportC stuff.
Re: Where do I find the version of SQLite used by PB?
Posted: Mon Dec 31, 2018 10:00 pm
by Paul
skywalk wrote:Or more directly
Code: Select all
UseSQLiteDatabase()
Debug PeekS(sqlite3_libversion(), -1, #PB_Ascii)
Is this a 3rd party lib you are using?
sqlite3_libversion() doesn't seem to be a native PB command.
Re: Where do I find the version of SQLite used by PB?
Posted: Mon Dec 31, 2018 10:29 pm
by skywalk
Sorry, left out the following:
ImportC "" ; UseSQLiteDatabase() must be called prior
sqlite3_libversion()
EndImport