sql

  1. W

    Share My Creation wmSQLtableSync - SQL table synchronisation between two databases [Class] [Source included] [B4A] [B4J]

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

    Share My Creation wmCRUD - a generic class for CRUD operations on an SQL(ite) database (with source code) [B4J] [SQL] [SQLite] [CRUD] [Class]

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

    Android Question Problems with SQL, external storage and Android 14

    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...
  4. Serge Nova

    Android Tutorial B4A Social Network Version 1.50

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

    Android Question XUIViews having issues with MODBUS TCP?

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

    Android Question Read Rows from a Excel File

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

    Android Example [B4X] Supabase - Database Joins

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

    Android Question Update .db File from CODE ||| Actualizar archivo .db desde codigo

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

    B4J Tutorial SQLite or MySQL database

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

    B4J Code Snippet [SQL] DButils v.2.5 for SQLite and MySQL

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

    Android Question Problem with Length function in B4XTable 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...
  12. Luis_FY

    Spanish Consultar el nombre de las tablas en una base de datos

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

    B4A Library ✨ Magic API Library: Transform Your MySQL Database into a REST API in Just 5 Minutes! 🚀

    ⚡️ 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...
  14. T

    Android Question B4A SQLite error when inserting data into database (Can't Find Table Name)

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

    Android Question scrollView cant connect to Sql database (internal Sql )

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

    Android Question b4a and sql concting problem

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

    Wish Sql/ResultSet

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

    Android Question B4XPages & SQL & TTS

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

    Share My Creation TODO-LIST

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

    B4J Question [B4X] jRDC2 - Issues with sql command not found

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