[Gambas-user] gambas and sqlite3
PICCORO McKAY Lenz
mckaygerhard at gmail.com
Thu Apr 25 14:57:07 CEST 2019
El lun., 15 de abr. de 2019 a la(s) 09:59, Peter Peyotle (
peterpeyotle at gmx.de) escribió:
> I query the sqlite3 version in Gambas Ide with "select sqlite_version ()"
> I get 3.11.
> I ask in the shell with "sqlite - version" I get "not installed". OK.
when you ask to ide the returned version are sahred lib
in the console that "sqlite" command are not installed only shared lib!
THAT WAS THE PROBLEM!
> I install the most recent from the sqlite page about compiling I get with
> "sqlite --version" the correct installed version. In Gambas, however, still
> the 3.11. And gb.db.sqlite3 also uses these because the features like
> "select * from pragma_table_info ...." are not supported. Only from version
> 3.16. So Gambas really uses the 3.11.
> On my laptop I have the version 3.18 installed via another source with ppa
> with "sudo apt-get install ....".
> Here also in Gambas then the version 3.18 is displayed and the pragma
> functions are available.
> I think there has to be an environment variable or something similar for
> gb.db.sqlite3 to use the installed sqlite version as well.
> So how do I get Gambas to support the installed latest sqlite3 version as
> best regards
> ----[ Gambas mailing-list is hosted by https://www.hostsharing.net ]----
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the User