I have a B4J app which inserts some data into SQLite and then does some update statements.
Two of the update statements are failing with this error;
java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such function: instr)
However "instr" is a known function if I run the same SQL statement in another SQLite client (eg DB Browser for SQLite).
Is the function missing from the jSQL library?
Two of the update statements are failing with this error;
java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such function: instr)
However "instr" is a known function if I run the same SQL statement in another SQLite client (eg DB Browser for SQLite).
Is the function missing from the jSQL library?