sqlite

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

Hello guys, I know this may not be the correct place to put this question but, since many of you have more SQL knowledge than me, I'll give it a try... I have this test FamilyDb SQLite database (attached), I adapted the following query from an example I saw and it works fine to list DECENDANTS...

Hello, I like to display greek words from an sqlite DB in a webview, using <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> in the head. But that seems to change nothing. Most characters are shown, but some are just left out, especially those with a tilde and accent as \...

I often use Sqlite for my apps and I came across "DB Browser". It's a free tool to browse and edit SQlite databases and tables. Download it from here: http://sqlitebrowser.org/ For B4J apps I recommend you to use the latest sqlite-jdbc-3.21.0.jar file. Get it from here...

Is it possible in B4A to determine the query type, that is data producing or non-data producing, without parsing the SQL? I can this in VB6 no problem as I have access to the lower level SQLite functions, eg PrepareStatementxxx, but I can't see a simple way to do this in B4A. RBS

Hi: I'm thinking in develop a simple product, that will need some data and the possibility of make reports and charts with such data. I think in SQLite for a simple way that permit package the app and database in a single installer and then the user can install it easily with not much hassle...

Hi! I'm trying to use SQLite as local / remote DB. I have successfully downloaded sqlite-jdbc-3.21.0.jar from the proper server: https://bitbucket.org/xerial/sqlite-jdbc/downloads/ Now arises the question: Where should I put the .jar file in order to get use of it? I haven't found the...

DDL code: [entrCreate] INT NOT NULL DEFAULT (strftime('%s','now') *1000) Make sure that the expression (strftime('%s','now') *1000) is enclosed in brackets.

SOLVED: B4A project using jRDC on local and remote servers just fine however I can't nut out how to successfully convert a retrieved blob from sqLite db and display image in an imageview. the update/insert side is this: Dim req as dbRequestManager Dim sSQL() As String Dim Buffer() As Byte...

This is a first version of the BindingNavigator Library, which wants to somehow reproduce the corresponding BindingNavigator of VB.NET What is needed? I want to get something similar to the tools available on VB.NET to link the views to the DB. As in the pictures. I am now working on a B4J App...

This new library is used to add some functions to the already precious SQLite library. Insertion, updating and reading of images in fields of type BLOB. Functions to add a table, a field. Update a field. Delete a row or table. List of tables, fields and typos of the fields contained in the...

This new library is used to add some functions to the already precious SQL library. Insertion, updating and reading of images in fields of type BLOB. Functions to add a table, a field. Update a field. Delete a row or table. List of tables, fields and typos of the fields contained in the...

Amigos quiero implementar este SQLCipher en mi app, pero me surge una duda que android es compatible con SQLCipher, estuve haciendo pruebas en mi J7 android 6.0.1 y funciona perfectamente, pero que hay de android inferior o superior, Alguien con alguna experiencia ?

Hi. I have a database in SQLite format and I need to do a partial search with a certain text. I would like to know what is the correct way to do it, since I have tried LIKE '%text%' but apparently does not yield results. Also, I used the UPPER (text) function to simplify the search. Dim DLG as...

I can write in vb.net and b4a and have a vb.net app which creates a Mysql hosted online. I want to be able to read that Mysql and get records from vb but NOT from b4a. I want to read the mysql from my ANDROID app I have asked an indian developers to write a class so i can attach to my Android...

Hi, I'm trying to use SQLite WAL mode to avoid locks while running several nested SQL statements like "Insert into MyDb from (select from MyattachedDb where...)". These queries need to be managed by a global transaction because several related tables are updated at the same time. I didn't...

Hello, How do I test to verify that an Open of an SQLite DB was successful, same for the Insert/Update/Delete commands, the only one that has a result code seems to be Select. Thanks

How to I set and Get correct DBVersion in SQL Browser and my application. From the sample code below, I get result as 1 meanwhile, in building the database, I set user version as 15. Screenshot below What am i doing wrong. Also included example project If...

Hi everyone! Ok, I keep getting this problem. I have a SQLite (edited) database in my project, and I use DBUtils (latest version) to communicate with it. If I run the code normally (pressing f5, even in Release mode), I get an error. But if I run it using breaks every couple of lines, or even...

SQLite3 has the REGEXP keyword. That means we can do SQLite queries like SELECT * FROM table1 WHERE col1 REGEXP '\d+[a-z]+\d*'; . Unfortunately, the REGEXP keyword references an SQLite user defined function that is not defined by default. That means if we want to use REGEXP in our SQLite...