sqlite

Hello, I have a SQlite Database and I want to use this command to insert/update or delete data and get returned the affected records. By SQL Syntax this is possible by adding the "RETURNING Columnname" command. Example: INSERT OR REPLACE INTO Proddetail (prodno,prodname,info) VALUES...

Hi all, I've updated my "Check Off" checklist app to allow syncing between Android devices (your own or other people who you invite to a list). This is a major update that I've been working on for a long time. It uses a tweaked version of CloudKVS to keep shared lists in sync, with the...

Hello. I've been researching, using AI, the best way to create and use a class for managing an internal SQLite database, but in a way that's cross-platform and accessible from the entire app (including a service). The solution we've found is to create a code module within a B4XPages project...

Yeap, that's right - just found solution how you will manage the Greek Letters with SQLITE ! The solution is to turn them all in latin! But how will search the database ? Here we are... First of all you are goind to initialize the database... sql.InitializeSQLite(File.DirApp...

After running some faulty code I ended up with a faulty entry in the SQLite SQLite_Master table. This was a table name called NON_CLINICAL.db.JOURNEYS. This name is faulty and was causing all sorts of problems. Note that is not a table name that is accessible with normal SQL. Now it is not that...

Hello as for B4A the initialize statement includes the possibility to create an empty database if the named database file is not found. sql.initializeSQLite(file.dirApp,Filename,true) I did not find the same in the statement to be used for B4J...

Hello, I have a problem in managing SQLite 3 database. Adding a new column to table works fine. deleting the column wether it has values or not raises an error I do'nt understand why. Dim cmd As StringBuilder:cmd.initialize cmd.Append("alter table ").Append(Tablename).append(" drop column...

🔐 TOOL released: SqlCipherConverter v1.0 – Simplifying SQLite to SQLCipher Migration! A common challenge when moving an existing SQLite database to SQLCipher is that encryption can only be applied to a new database. This makes migrating existing data challenging without specialized tools. To...

Name: TD_recordset Type: Custom B4A Class (b4xlib) Version: 1.0 State: Testphase Licence: free for personell use, free for commercial use after donation. Download here TD_Recordset is a custom class that allows you to store and manage selected data from an SQLite or SQLCipher database...

Status: UPDATE Name: TD_DBNavBar Code: B4A Type: b4xlib Version: 2.6 License: Royalty free for personal and commercial use External License: Usage of BR_Button (C) Lucas Siqueira Author: TechDoc G. Becker Attached: Download Link Update...

MiniORMUtils Version: 4.30 This library can be use for creating database tables and performing CRUD operations. It is suitable for B4X apps, non-UI web app or REST API servers. It is useful to return the query results as JSON since the rows are list of maps. Currently it supports SQLite (for...

Hello everyone. Just a thing: I wish to do a SUM of amounts in a table (column named 'montant': With this code... Dim va As Double=sql.ExecQuerySingleResult( _ ' "SELECT SUM(montant) FROM depenses WHERE idlieu = " & f ) where f is an id in a list ( 'Dim f As Int=li.Get(t)') appears...

I come from a web/PHP background and use MySql often. So I want to use SQLite since the syntax is pretty much the same, but the resources I found are either for B4A or is pretty confusing. Does anyone have a thread or resource I can use as reference? Or can someone point me in the right...

Introdução ao SQLite O SQLite é um banco de dados leve e rápido, muito usado em aplicativos Android para armazenar informações. Ele não precisa de um servidor separado para funcionar, pois armazena os dados diretamente em um arquivo. Com o SQLite, você pode: Armazenar informações de forma...

PocketBase was created to assist building self-contained applications that can run on a single server without requiring to install anything in addition. The basic idea is that the common functionality like crud, auth, files upload, auto TLS, etc. are handled out of the box, allowing you to focus...

SQLite has the string function Instr, which finds the first occurrence of a specified string in another string. There is no InstrRev function though to find the last occurrence of a string within another string. As I needed this I made another custom SQL function (I have several of these) to do...

hi. Which method of connecting to the database is optimal? My focus is on memory usage. 1-Persistent connection Connects to the database from the start of the program and does not close until the end of the program. 'mainform public SQL1 as SQL sub start SQL1.InitializeSQLite(""...

when I want to validate user and password I click on the botonborrar_click but the program closes, what could be happening? #Region Project Attributes #ApplicationLabel: B4A Example #VersionCode: 1 #VersionName: 'SupportedOrientations possible values: unspecified, landscape...

Hi, I'm trying to display a time that is in 24 hour format to a 12 hour format. To do this conversion I'm trying to use SQLite's <strftime> but I can't get it to work in B4J. There is no error, the query simply returns <null>. It's worth mentioning that if I test the query in other programs to...

B4A What is the most convenient way to save APP settings? Is it similar to the Windows INI file or using SQLITE? For a very small amount of data, does it take up too much memory to use a database? If reading or writing is closed immediately, will the APP increase the memory? Asked CHATGPT AI, he...