Where do I find the version of SQLite used by PB?

[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

[spikey]

Code: Select all

SELECT sqlite_version();

The resulting column is a string in x.x.x format.

[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.

[Paul]

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.

[skywalk]

Sorry, left out the following:
ImportC "" ; UseSQLiteDatabase() must be called prior
sqlite3_libversion()
EndImport