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')
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')
Last edited: