Hi Helpers :)
I have a sqlite db with multiple tables, I am not sure why but I no matter what I do, I can not read from all the tables in my DB, I have searched in sqlite documentation and saw some examples which are not different than what I have, but for some reason it fails, when I try the...
What is the best datatype if you want to store a UI element in a SQLite database? e.g. All the Data Associated with a Label or a more complex element.
In my case the UI elements are quite complex, a simple copy to value approach won't work.
I am successfully putting image files into an Sqlite blob, then later reading them from the blob field, however I end up with them in a bitmap object which I then have to put into an imageview. I can see the activity background image, so I k ow I have the blob as an image object, I just need to...
This is my first question, so please bear with me.
I am reading a field from SQLite to populate a Label inside a ScrollView that sits on a tab in a TabStrip.
It all seems to be working fine, but it seems that the very long text strings are being truncated. For example, one string in the DB is...
UPDATE: BANanoSQLite now available for actual sqlite db file CRUD functionality.
This is part 1 of a series of my explorations using SQLite as a backend to a BANano app. I need a way to persist the data to a database, but thought of a serverless database for now.
1. Create the...
UPDATE: BANanoSQLite now available for actual sqlite db CRUD using PHP
I've been wondering if I could be able to do this as I want to distribute my app with an already existing SQLite.DB database for READONLY access. No, this is not WebSQL but a pure SQLite database.
At first I...
Is it Possible to add a Database File (Sqlite) in Andriod Application. If yes how it is possible. My requirement is this database file install in my Andriod Device during installation of APK file. So that I can read,edit, modify its content.
'Tests whether the given table exists
Public Sub TableExists(SQL As SQL, TableName As String) As Boolean
Dim count As Int = SQL.ExecQuerySingleResult2("SELECT count(name) FROM sqlite_master WHERE type='table' AND name=? COLLATE NOCASE", Array As String(TableName))
Return count > 0
If we have HTTP API and get the JSON reply that should be saved into SQLite DB table - the API may be changed, extra fields can be added into JSON suddently...
The SQLite DB structure is always fixed, so the task is to automate any JSON import (insert to or update the table), but only...
Is there any way to Auto-Update or Auto-Refresh an SQLite Table in WebView - WITHOUT MANUALLY REQUESTING, such as clicking a Button
Like in Erel's Data Collection example:
This more a suggestion/idea than a real snippet or other code.
If you have installed Google Drive on the PC where you are running your B4J-App (I use B4J as a inhouse server solution with SQlite) it has just a simple folder which you can use like we know it. Just copy backup files to this...
Check for updates here: https://bitbucket.org/xerial/sqlite-jdbc/downloads/
Newest version (18.8.2018): sqlite-jdbc-3.23.1
Just copy the newest version to the AdditionalJar folder and delete the old one. Set the reference in "#Region Project Attributes"
#Region Project Attributes...
What is an audit trail? As per Wikipedia...
An audit trail (also called audit log) is a security-relevant chronological record, set of records, and/or destination and source of records that provide documentary evidence of the sequence of activities that have affected at any time a specific...
I have same problem again.
my customlistview taking more than 4 min for nearly 1200 records of sqlite
my code is :
cursor = Starter.year.ExecQuery("select * from GL where FBOOK='G001' order by FDESC")
i make function to get value of any field ::
Sub function(sqlite As SQL,book As String,accode As String,return_field) As String
Return sqlite.ExecQuerySingleResult2("select '" & return_field & "' from GL where FBOOK = ? and FACCODE = ?", _
After inserting numeric value in database and the value is round
I have a php code and get value = 152448.52
my b4a code is
amt = m.Get("mamt")
sql.ExecNonQuery2("INSERT INTO gl " & _
"(fbook,faccode,fdesc,fplace,fitcu,fin1,ftype," & _...