B4J Question SQLITE Version in B4J

[lip]

I'm using B4J on a Pi3 with SQLITE.

An insert Query that runs fine on B4A is failing on the Pi. The syntax should be OK for SQLITE 3.7.11 and above.

I'm not sure if the SQLITE version is part of Raspbarian or part of B4J? Or if it is likely to be above 3.7.11?

The Query is an INSERT of multiple records using () VALUES () syntax:

INSERT INTO PKDELETE (Param) VALUES ('DBVersion'),('DefaultLinkToSelf'),('DefaultWorkingDays')

 

[Erel]

I'm not sure if the SQLITE version is part of Raspbarian or part of B4J?

You can use any version you like. Just download the correct version, copy it to the additional libraries folder and reference it with #AdditionalJar.

https://bitbucket.org/xerial/sqlite-jdbc/downloads

 

[lip]

You can use any version you like. Just download the correct version, copy it to the additional libraries folder and reference it with #AdditionalJar.

https://bitbucket.org/xerial/sqlite-jdbc/downloads

Thank you so much. I had #AdditionalJar: sqlite-jdbc-3.7.1 in my project attributes so I guess I really should have spotted this! I downloaded 3.15.1 from bitbucket.org, changed the reference and it works perfectly. Thanks again.