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...