spatialite

I am familiar with the SpatiaLite db in general and have queries running on db's created in QGis I have created a db in SpatiaLite and now need to add a table,a Geometry Column and insert rows I am unfamiliar with the B4a syntax. Any examples or help would be appreciated

Just trying out the new SQLCipher 4, for now with an unencrypted database. SQLCipher 4 can connect to this database fine, but there is a problem with Spatialite. Spatialite connects to it's own (so a different database file) database, which is unaltered. Not sure now what the interaction is...

Running this SQL in the spatialite gui application: SELECT ID FROM P_POINTS WHERE Within(GEOMETRY, polygonfromtext('POLYGON(-2.165476 52.604321, -2.167375 52.606777, -2.16444 52.606914, -2.163287 52.604595, -2.165476 52.604321)', 4326)) = 1 Geometry is the column in P_POINTS holding lat/lon...

Is this possible? I get this error when installing to the phone (Samsung S9): ** Activity (main) Create, isFirst = true ** Connect2DB, Starter.strAppDir: /storage/3637-6230/Android/data/b4a.sqlitelight1/files Connect2DB, strDB: PhonePats.db java.lang.UnsatisfiedLinkError...

Need help with the wrap for Objective-C lightweight spatial SQLite/SpatiaLite library for B4i Sample Project : Github project. https://github.com/andreacremaschi/SpatialDBKit. Or equivalent of B4A Spatialite library B4A. https://www.b4x.com/android/forum/threads/spatialite.36296/ Please...

Please wrap this Objective-C lightweight spatial SQLite/SpatiaLite library for B4i. Github project. https://github.com/andreacremaschi/SpatialDBKit

Please any equivalent Spatialite libray for B4i. https://www.b4x.com/android/forum/threads/spatialite.36296/ Thanks