sqlite

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

Mi primera app en b4j, compilada con el empaquetador interno y funciono!. solo que queda muy grande y no lo pude subir Es una aplicación sencilla. pero me dejá gran satisfacción. Todo realizado con la ayuda de los comentarios y foros. Obviamente a la documentación de ERel. La aplicacion...

Check out the second spoiler. It's another example of the possible integration of this application. This small application might be a great help in creating reports and SQL statements. In the first tab you can select a SQLite database file and get all the tables in that database. In the...

Good Morning to you, as I understood the database itself and the Resultset are two independent Objects. INSERT/UPDATE DELETE will change the Database Data but the Resultset Data is not synchronized and is not effected by those actions. To solve this I save the SELECT statement and after doing...

Why/What? A CloudKVS didn't cover my needs so I developed this class. Features: - It synchronises a table between two SQL instances; one is called the Client, the other the Server - All columns that exist in the Server table must be present in the Client table - Additional columns that exist in...

Here is a brainteaser for any B4X insommiacs out there..... I have a language database in SQLite with around 30k words. Given a string comprising 4 to 12 characters, is it possible to devise an SQL query that extracts all matching words for every possible permutation of those exact characters...

Good day. I am new to B4A and I want to create an application with SQLite database. I set up the DB Browser properly and added the sql file to the file manager in b4a. But the problem is I always encounter this error "android.database.sqlite.SQLiteException: no such table: user_table (code 1...

This is a fully functional ToDo app for Android and IOS (B4A and B4I) With this B4X project I show how to develop a modern and good looking cross-platform app with B4X. Features SQLite Database structure Task due notifications Dark and Light Mode Switch on the fly, without app restart...

Abstract Another one in my 'I don't like doing repetitive stuff' repertoire. The rationale for this one is to avoid having to code the 'boring stuff', i.e. CRUD for data tables (usually slightly or completely different than others from other programs) in a new program, again and again. The idea...

I wanted a quick way to generate a layout file (add the views and their names and events) to then fine-tune it with the Designer - MakeBxL does that, either from - a list of names (for the views) that you add in its TextArea, or - from an SQLite database table Some additional options are...

Las experiencias que me puedan contar son bienvenidas, los pongo en contexto: Tengo una base de datos SQLite la cual contiene datos valiosos para el usuario, eh probado las siguientes formas de hacerle una copia de seguridad: Forma1 Subirla al Google Drive del usuario(Funciona perfectamente...

hi guys, I have a database table that has a field called ID and the field is autoincrement. Suppose it has 5 records whose IDs are from 1 to 5 respectively Now I insert a record manually with ID 10 Next time when inserting a new record, it will automatically insert the number 11 I want to...

#Region Shared Files #CustomBuildAction: folders ready, %WINDIR%\System32\Robocopy.exe,"..\..\Shared Files" "..\Files" 'Ctrl + click to sync files: ide://run?file=%WINDIR%\System32\Robocopy.exe&args=..\..\Shared+Files&args=..\Files&FilesSync=True #End Region 'Ctrl + click to export as zip...

Hi One is able to host Pocketbase on Railway.app. This deployment is based on Docker Image. You need a GitHub account. 1. Create an account on Railway.app and link to your Github. 2. Click this link to publish a PocketBase instance on port 8090 there...

Project Runner is a non-code tool for developing Android apps using SQLite. This tool can work without an Internet connection. This application provides an intuitive user interface for creating and updating SQLite databases, adding and editing tables, defining and managing relationships between...

Hi, Can't figure out why this works: Dim RS3 As ResultSet = Main.SQL2.ExecQuery("SELECT Fullpath, Filename, Size, Date, Time FROM DblFiles WHERE Fullpath = 'C:\temp\{C}\'") But this does not, while the variable beholds the same string: Dim RS3 As ResultSet = Main.SQL2.ExecQuery("SELECT...

I have an application with a SQLite database. How can I make it export table to CSV, JSON, or any other format, and upload it to FTP or send it via email? In principle, these will be very small tables, with a maximum of 2 keys, 10 fields, and at most a few thousand records. Later I am also...