sql

Just started to experiment with B4XTable, using the provided example project as provided by Erel in the first post regarding B4XTable. I added some extra options to the search facility, edited the Subs: Public Sub BuildQuery Private Sub ImplUpdateDataFromQuery Public Sub BuildQuery...

Saludos amigos, estoy tratando de hacer una app usando SQL, hasta ahorita no hay problema para crear desde mi app una base de datos interna y crear n cantidad de tablas para manejar una por día por poner un ejemplo. El problema principal que tengo es que si nombro a una Tabla A1 y vuelvo a...

MAGIC API Usage Instructions: 1. Upload the api.php file to your server. 2. Edit the header with your connection data. 3. You're ready to communicate your app with your mobile and desktop applications. Note: The API works fine without the library, but the library will help you communicate more...

Hello, Friends! As I am new to B4A and I am just a student, I am working on an app/game that needs to connect to a database. In this case, I am currently using DB Browser for SQLite. I created a table named "Questions" in DB Browser and has some attributes in it. But when I try to insert...

Hello, I had asked about my problem near week ago and it solved but when I made a new Activity and new layout with scrollview Unfortunatly I faced conecting scrollview and Sql table ,I couldnt figur out how to solve it even I tried so much thus I decided to ask if any body can give me hand in...

Hi strugle with a problem that it's really dirve me crazy😭 my app made of layout with a Listview I made a sql declare ir intialize it but when I run program it give me some eror I've been working on it for 10 days and 8 hrs per day but I couldnt solve it becuse im not programer please guide me...

I think that will be very useful when I can get number of records in ResultSet. When I want to show user how the process running and how long will take for all updates in database, I need first to calculate number of all records (select count(*) from MyTable where ...) and after this I can show...

I will be remaking my old B4A app with multiple Activities. I used SQL and TTS here. Now I want to use B4XPages. 1. I used SQL.Initialize... in B4XPage_Created in B4XMainPage file. Where is the best place to put SQL.Close? 2. I will use TTS.Speak on some pages. Where is the best place to place...

Hello, I share my application to create task lists. If you want to try it, you can download it from here. The source code is also for sale at the following link: https://b4xapp.com/item/todolist-source-code- features: sqlite database Notification when a task is due or overdue Beautiful UI...

Hello I'm experimenting with the jRDC2 tool, but at this point, I'm receiving a weird issue. I created a sql query, just like in this tutorial, but for some queries I receive the message that the command could not be found out of the config.properties file. jRDC2 server: #SQL COMMANDS #...

Hello, hope you are all fine. Today my question to the professionals is concerning the use of SQL or SQLCIPHER Library. If we do any sql action via the library like an insert a.s.o. it might be possible to fall into an error situation because for example we are going to insert a record with a...

Library: TDDBUtils.b4xlib Language: B4A Version 1.8 Manual: Version 1.5.2 (did some checks and improvements, added SQLCipher tutorial) Status: Work in Process (C) This library is free for non commercial use other use see manual. New to 1.8: optimized code fixed some errors Added grouping and...

Hi All, I have a requirement to use a Raspberry PI as a Local DB server, but I need to support both Android and iOS clients. I was looking at this post: https://www.b4x.com/android/forum/threads/mariadb-does-not-wait-for-query-results.132054/post-833507, and it seems to be straightforward with...

HAllo, gibt es in B4A eine Möglichkeit, z.B. nach dem Löschen von Datensätzen, die Reihenfolge eines autoincrement-Feldes wieder upzudaten. Was ich bisher im Web gefunden habe funktioniert anscheinend unter B4A nicht, ich erhalte ich eine Syntax-Fehlermeldung. SQL1.ExecNonQuery2("ALTER TABLE...

Hi, I am using the example in https://www.b4x.com/android/forum/threads/background-location-tracking.99873/#content. I added the required line to my manifest. The app pauses when the screen turns black. I did not change a thing besides that I added a SQL table that holds some data and when...

Hello, hope you are fine. At present I have a probleme that I did not have before updating b4a suite to 11.20. and I need professional help. Sub Process_Globals Public SQLite As SQL ' Database object Sqlite Version 3 End Sub Sub Service_Create Try ' # copy...

Hallo, ich habe eine App geschrieben, welche einwandfrei funktioniert und Daten über Bluetooth empfängt und diese in eine SQL Datenbank mithilfe der SQL Bibliothek schreibt. Dies funktioniert alles super. Nun wäre es super, wenn parallel dazu alle Werte, welche in die lokale SQL Datenbank...

I have been using other people's work on this site for a number of years as I tried to learn how to code in this environment. I recently retired from a career in data collection programming involving writing applications to capture data from the shop floor and updating a remote sql server...

I sometimes build long complex SQL statements from code, and it takes a lot of effort to code and test, so figured why not build a class to do it for me? Here's a very simple class (the example is in B4J) to build SQL statements from code. It consists of a very basic screen (only needed for the...

Hi all, When my app is initially installed, it comes with a SQLite database. I'm working on code that allows end users to replace this SQLite database after the app has been installed - I would have them download and save the new database to the device's "Downloads" folder. During the...