Check SQLite version currently used by PB - generic way

[Marlin]

You can use this as a simple, generic way to check what version of SQLite
your current version of PB uses:

Code: Select all

EnableExplicit

Debug UseSQLiteDatabase()

Debug OpenDatabase(0, ":memory:", "", "")

Debug DatabaseQuery(0, "select sqlite_version()")
Debug NextDatabaseRow(0)
Debug "PB currently uses SQLite version: " + GetDatabaseString(0, 0)
FinishDatabaseQuery(0)
CloseDatabase(0)

I find 3.6.23.1 -> supporting foreign keys,
while my installed commandline version 3.5.7 does not.
-> Time for updating.

[IdeasVacuum]

Brilliant tip Marlin, thanks for sharing it