<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p><span class="tlid-translation translation" lang="en">Hello and
good day.<br>
<br>
I use Gambas 3.12.2 with Linux Mint LXDE 18.2.<br>
How do I tell Gambas which Sqlite3 version to use?<br>
I query the sqlite3 version in Gambas Ide with "select
sqlite_version ()" I get 3.11.<br>
I ask in the shell with "sqlite - version" I get "not
installed". OK.<br>
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.<br>
On my laptop I have the version 3.18 installed via another
source with ppa with "sudo apt-get install ....".<br>
Here also in Gambas then the version 3.18 is displayed and the
pragma functions are available.<br>
I think there has to be an environment variable or something
similar for gb.db.sqlite3 to use the installed sqlite version as
well.<br>
So how do I get Gambas to support the installed latest sqlite3
version as well?<br>
<br>
best regards<br>
Klaus-Peter</span></p>
</body>
</html>