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


> 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
> well?
> best regards
> Klaus-Peter
> ----[ Gambas mailing-list is hosted by https://www.hostsharing.net ]----
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.gambas-basic.org/pipermail/user/attachments/20190425/a0fecda7/attachment.html>

More information about the User mailing list