I put this in a button.
Code: Select all
on MouseUp
local lnVer, lcSql, lnDbId
-- Open In Memory database
put revOpenDatabase("sqlite",,,,,,,) into lnDbId
put "select Sqlite_Version()" into lcSql
put revDataFromQuery(comma,return,lnDbId,lcSql) into lnVer
answer "Version: " & lnVer
revCloseDatabase lnDbId
end MouseUp
Sqlite is Upto version 3.9.2 as of now and there have been many critical bug fixes (and speed improvements) since 2005. Is this an error on the return string or are we that far behind?
Now the output says 3.15.0
The closest to that numbering system I can find is 2007-04-09 - Version 3.3.15 which is 2007 if we assume the .3 is a given.
The next closest is 2005-03-11 - Version 3.1.5 from 2005 - either way it's 10 years old and we had a crowdfunding in 2016 to bring it upto date.
Can anybody confirm this? And Panos I know you are reading this - what is the state of play.
Regards Lagi