[Gambas-user] gambas and sqlite3

Gianluigi bagonergi at gmail.com
Tue Apr 16 13:41:41 CEST 2019

You could write what the terminal gives you:
(first you need to install the sqlite3 command, no sqlite only)
sudo apt install sqlite3
sqlite3 -version

in Mint 19, I get: 3.22.0

To indicate to Gambas what you want to use you must write:
Connection.Type = "sqlite3" [0]


[0] http://gambaswiki.org/wiki/comp/gb.db/_connection/type

Il giorno lun 15 apr 2019 alle ore 15:59 Peter Peyotle <peterpeyotle at gmx.de>
ha scritto:

> Hello and good day.
> I use Gambas 3.12.2 with Linux Mint LXDE 18.2.
> How do I tell Gambas which Sqlite3 version to use?
> 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.
> 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/20190416/52b9e5ee/attachment.html>

More information about the User mailing list