sqlite

Why is it not possible to run a query against SQLite that contains functions like row_number() or rank() ? e.g. 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...

Hi Everyone! 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

Hi Everyone! I've been seeing the example of B4Atable editable : https://www.b4x.com/android/forum/threads/b4x-b4xtable-editable-table-and-export-to-csv.102847/ 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...

Hi, 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? Thanks Andrea

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

Hi Everyone! 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: tabla...

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: https://www.b4x.com/android/forum/threads/android-sqlite-viewer.9197/#content Is this still current or is there another simple way to view my database?

Hello, 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 ? Thanks Michel

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

Hi all. I'm trying to save some of the data I get from the gps in a database. With the following code I have no problems. Query = "INSERT INTO `GpsData`(`Id`,`UnixTime`,`Lat`,`Lon`,`Speed`,`Bearing`) VALUES (NULL,'" & UnixTime & "','" & Lat & "','" & Lon & "','" & Speed & "','" & Bearing &...

Hola a todos. Estoy tratando de guardar en un base de datos, algunos de los datos que obtengo del gps. Con el siguiente código no tengo problemas. Query = "INSERT INTO `GpsData`(`Id`,`UnixTime`,`Lat`,`Lon`,`Speed`,`Bearing`) VALUES (NULL,'" & UnixTime & "','" & Lat & "','" & Lon & "','" &...

Ola UPDATE 2020-05-19: Please use this library instead Update: BANanoSQLite1 Example If you are opting for MySQL connectivity, BANanoMySQL is available here. My journey finally has led me to complete a basic wrapper that one can use for PHP SQLite access. Initially, we tried...

I am learning how to use SQLite and DbUtils. I have written code that creates a db and a table. It then writes values to the table. However it does not seem to be able to retrieve them. Not too sure what is wrong with the code, as it is pretty much what is in the tutorial video. Here is the...

Hola, tengo un problema es que no alcanzo a comprender del todo como "Bloquear" una petición HTTP por que utilizo Wait For (Resumable). Miren el caso: Selecciono mis elementos de mi base de datos local, y luego envío los datos a una API pero no se envían de forma apropiada por que, como es un...

Hello, I have a problem is that I do not understand at all how to "Block" an HTTP request because I use Wait For (Resumable). Look at the case: I select my items from my local database, and then I send the data to an API but they are not sent properly because, as it is a "non-blocking" event...

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