sql

Good Day hopping you are all well, I have a question concerning Database and Resultset. For Example if I am performing an SQL INSERT or UPDATE the data saved in the database ist changed but the data in the resultset is not! I understood that this objects are independend from each other and that...

I am trying to create an SQLIte database, build and populate its tables from code using the SQL object from jSQL library. I want to read the SQL script/queries from a text file but am finding when I do that I get an error: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database...

Hi there. I'm having trouble updating my sql database using ExecQuery2. It works when I'm trying to use SELECT command. But I think it's not working when I'm trying to use UPDATE command. This is my table: and here is the interface of my app: users can add their own titles using that plus...

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

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

Hello everyone My name is Juanjo, I've been using B4A since a long time (I started with b4ppc) but at an amateur level. I hope you understand my sort knowledge on this. Since the beggining y made a program that uses SQlite database to adquire data manually, only with the keyboard, I've been...

Hello every one, The old version (1.30) of this social network can be found in this link: https://www.b4x.com/android/forum/threads/b4a-social-network-version-1-30.141765/#post-921065 After several days of work, version 1.50 of this social network which brings the correction and several...

Hello team, i have i little strange issue, the thing is when im trying to compile my app, gets me this error when this XUIViews Library is active Dex merge Error Error in C:\Android\tools\..\extras\b4a_local\unpacked-modbustcp-63803597595704\dex_v1\modbustcp.zip:classes.dex: Type...

Hello guys, hope you are doing well! I have been trying to extract some values of a Excel, everything just works fine but im having some issues with the reading of this values. Sub CC_Result (Success As Boolean, Dir As String, FileName As String) Dim suC As StringUtils...

https://www.b4x.com/android/forum/threads/b4x-supabase-the-open-source-firebase-alternative.149855/ In the following example I make a join into the "public.users" table and need the column "username" from it. Dim Query As Supabase_DatabaseSelect = xSupabase.Database.SelectData...

So basically what im trying to do is after that i have created some tables in a database, add some values to this tables is update all .db file. I already had initialize my SQL .db file and check if its no duplicate and stuff like that. All works like a charm but when i close my app, this...

For any project where a database is required - it's very important to have possibility to see the database data, to debug the app. If the app is used on a remote server host, and the database is getting bigger and bigger - it's not comfortable to see file-based SQLite database, as file copying...

One my project has to be using not only SQLite database (actually, two different ones, as separate classes), but MySQL also, due to big size that now is more convenient to see via web-browser remotely (without downloading big SQLite db file). So, i have combined 2 DBUtils modules: latest...

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

⚡️ Unleash the API Power: Magic API for Seamless B4X Integration 🌟 Greetings, B4X enthusiasts! Today, I'm thrilled to unveil the magic behind our latest creation—the Magic API. Elevate your B4X applications with streamlined API integration, simplifying CRUD operations effortlessly. From...

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