Check SQLite version currently used by PB - generic way
Posted: Sat Dec 18, 2010 11:28 pm
You can use this as a simple, generic way to check what version of SQLite
your current version of PB uses:
I find 3.6.23.1 -> supporting foreign keys,
while my installed commandline version 3.5.7 does not.
-> Time for updating.
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)
while my installed commandline version 3.5.7 does not.
-> Time for updating.
