B4J Question [Solved] SQLite use with new Version?

mw71 said:

hi,

i have
- add #AdditionalJar: sqlite-jdbc-3.31.1 (in Main Window at Project Attributes, File in Libary Folder)
- use ist with sql_k.initializesqlite
but with

B4X:

Log(SQL_K.ExecQuerySingleResult( "SELECT sqlite_version()"))

(after load a File) i get 3.7.2 ???

What's the rigth way to use a newer SQLite Version??

Click to expand...

mcqueccu said:

I tried your code and it gave me the correct versions, with 2 different jdbc driver
'#AdditionalJar: sqlite-jdbc-3.27.2.1
#AdditionalJar: sqlite-jdbc-3.36.0.1

Click to expand...

2010-08-24 (3.7.2)​

What's the rigth way to use a newer SQLite Version??

Click to expand...

Unfortunately it always uses the 3.7.2 JAR from the internal directory (is this possible through a library?).

Click to expand...

oparra said:

copy jar to Additional Libraries

See:
View attachment 123782
B4J:
View attachment 123783
View attachment 123784

Click to expand...

oparra said:

sample:
View attachment 123787
Main:

B4X:

#Region Project Attributes
    #MainFormWidth: 600
    #MainFormHeight: 600
    #AdditionalJar: sqlite-jdbc-3.36.0.3
#End Region

Sub Process_Globals
    Private fx As JFX
    Private MainForm As Form
End Sub

View attachment 123785

Click to expand...

Version=1.21
B4J.DependsOn=B4XFormatter.b4xlib, jSQL, sqlite-jdbc-3.7.2
B4A.DependsOn=B4XFormatter.b4xlib, SQL
B4i.DependsOn=B4XFormatter.b4xlib, iSQL

Click to expand...

#Region Project Attributes
    #MainFormWidth: 600
    #MainFormHeight: 600
    #AdditionalJar: sqlite-jdbc-3.36.0.3
#End Region

Sub Process_Globals
    Private fx As JFX
    Private MainForm As Form
End Sub