sqlite

HI, All 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...

Hi guys, 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: https://www.b4x.com/android/forum/threads/server-data-collection-solution-device-desktop-and-web-reports.37254...

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

Ola 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 7.12.00 7.16.00 my code is : cursor = Starter.year.ExecQuery("select * from GL where FBOOK='G001' order by FDESC") Dim...

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 = ?", _ Array As...

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," & _...

Can I add all record of cursor to spinner without using spinner.add(cursor.getstring("accode"))

Hii Expert I want to make app that download data from mysql and insert it into android db file. Plz give me example or sample code. I am new in B4A

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

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.