Hopefully this is a quick question. I'm trying to do some array processing and sorting and think it would be easier to do this within a database environment, but don't want to have to go back to the mySql server for this temporary stuff. I think an in memory SQLite connection would work just...
Long working apps have DB that grows and grows. It must be controlled, when records qty is very big, and most old data should be deleted:
Sub Clean_SQL(tables() As String) As Boolean
'Starter.SQL is already open
Dim TotalRecordsLimit As Int = 20000 'set yourself according to the...
Hello every pro,
I use the code below to insert datas in a table which name is pvpt (for geography)
synt="INSERT INTO pvpt(pays,villes,lat,ns,lon,ew,abrv,ajout) VALUES " & _
"('" & _
txtPays.Text & sep & _
txtSaisieNelleVille.Text & sep & _...
In the code below, when I extract datas from a table, I find a special behaviour decribed here:
The log renders the good answers for two datas LAT and LON, but if I try to put them in two EditTexts, the result is 0.
Do I miss something ?
Who tried to develop it ? I think, it's very interesting task.
For ex., we make:
1) choosing the subject, area for the app - say, fishing (or electrotechnics...)...
2) Develop the database structure
3) invent the interface template for db filling by the expert
4) invent the interface...
I am trying to do a join on 2 different SQLite tables. Here is my SQL Statement:
Select * FROM tbl_items WHERE tbl_categories.cl_reference = 'cat01' AND tbl_categories.cl_song = tbl_items.cl_song ORDER BY cl_last_access_time ASC
I keep getting the following error...
I wish to use an sqlite db on a tablet's external sd card.
The tablet is running Android Build version 6 with API Level (19 KiKat).
I tried ExternalStorage.zip. I had to edit the manifest to a minimum of 19 to get it to install.
It now installs and runs, but when I push the Pick Folder...
This wish is for enabling jSQL's locking for alternative SQLite JDBC drivers. Various methods for enabling this could be (this is a repeat found in my post here: https://www.b4x.com/android/forum/threads/sqlite-jdbc-driver-with-encryption-and-authentication-support.110565/#post-690205):
I have an app that stores an image in a SQLite BLOB and happily retrieves and displays it in a form. However I need to push that up to a PHP Webserver and store it in the corresponding MySQL BLOB field.
Do I have to retrieve the BLOB, store it locally as a file then Post it to the Server for...
1. Add the database that you want to be...
Why is it not possible to run a query against SQLite that contains functions like row_number() or rank() ?
Dim RS As ResultSet=Sql1.ExecQuery($"SELECT ROW_NUMBER () OVER ( ORDER BY cid ) RowNum, ostatus, cid, itemcount FROM orders;"$)
Error in Log:
DBeavear and DB Browser for SQLite...
I'd like to know if exists some function to create a unique code for a field in a sqlite table type of String or number, no matter how long it is. I had thought to collect hour minutes and seconds in a single line to be unique and not repeat but I don't know how to do it. Thank you
I've been seeing the example of B4Atable editable :
and it works perfect, but that edits any field that the user wants and I would like to know if it is possible to edit in the...
I understand how to use Wait For in a B4J Server Handler. However I have no idea how to pause a server handler class waiting for some data in a SQLite database to change.
Anyone so kind to help?
I'm trying to understand how best to update SQLite from a B4xtable and would like some advice.
I'm struggling slightly because the help docs b4xtable help is showing nothing for me for some reason, plus the closest examples I've found
B4xTable load data - loads from sqllite but...
Well.. I developed an app and I'm testing it on leapdroid 18 (android 4.4) it works fine.. but when I install it on a real device with Android 5 or 6 my app crashes. It seems the database file is not copied to the sdcard. Im using DBUtils 2.06 and my db file is copied in the file...
Hola a todos. Soy Nuevo en el foro y en B4A igual. Estoy desarrollando una app que sume 2 valores en ($) que vienen de 2 lugares. Un valor viene de la BD (sqlite 3) y la otra por parte del usuario. Estoy usando
la libreria dbutil para conectarme a dicha Bd la cual esta compuesta asi:
I am looking for an Android Based or B4A (in App) sqlite viewer.
I see there is a very old thread from 2011 with one:
Is this still current or is there another simple way to view my database?
Ok, i know that no Sqlite data will be lost during an upgrade, only when we uninstall the app.
But if i need to change the data format between 2 versions, (in this case, add a field)
i would have to implement some migration code.
what is the just method for doing this ?
Colleagues, I'm pretty worried, I should do this migration from SQLCiper V1.50 to V1.60, as we all know from the 64BIT binary.
The problem is generated because the database created in V1.50 will not be compatible with V1.60, so as I do to pass that data to the new database when updating the app...