crud

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

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

https://www.b4x.com/android/forum/threads/b4x-supabase-the-open-source-firebase-alternative.149855/ This is a very simple tutorial on how to use the storage bucket options. CREATE Creates a new Storage bucket Name - A unique identifier for the bucket you are creating Dim CreateBucket As...

https://www.b4x.com/android/forum/threads/b4x-supabase-firebase-alternative.149855/ This is a very simple tutorial on how to use the CRUD options. A more detailed tutorial is coming soon. CREATE Dim Insert As Supabase_DatabaseInsert = xSupabase.Database.InsertData Insert.From("dt_Tasks") Dim...

Supabase is an open source Firebase alternative. It provides all the backend services you need to build a product. Supabase uses Postgres database with real-time capabilities. Basically, supabase provides an interface to manage postgres database that you can use to create table and insert, edit...

Well, I ve decided to create a Form-View Generator (B4J - B4A)... that creates Forms with B4XTable + with no writing code at all... The Designer is in B4J (like FormBuilder), the produced code/files working at B4A too !!! Well.. after one month of programming... I want to share / sell my...

Well, I ve decided to create a Form-View Generator (B4J - B4A)... that creates Forms with B4XTable + with no writing code at all... The Designer is in B4J code, the produced code/files working at B4A too !!! - It uses SQLite, easily can change at any SQL Database (mysql, mssql... etc) - You...

Updates: Web API Server 2.0 is available. Check https://www.b4x.com/android/forum/threads/project-template-web-api-server-2.143310/ Version: 1.16 Description: Create Web API Server with CRUD functionalities Sample application: [B4X] Todo List based on Web API Template: Web API Server...

Hola a todos: Por fin me he puesto a probar un poco con B4XPages, y he empezado a adaptar el ejemplo B4XPages + B4XDrawer Creo que he visto algunos ejemplos con php + mysql para hacer login, etc... pero he visto pocos con jRDC2. Los datos de la base de datos y la interfaz gráfica son bastante...

Hi all: I'm starting (at last) to work with B4XPages, so I've started to adapt the B4XPages + B4XDrawer example. I think I’ve seen more examples with php + mysql, but no projects with Jrdc2. Maybe the dummy data and the UI are too basic, but you can get some ideas. What do we need? - A...

Ola UPDATE 2020-05-23: Please use this library instead This class is for CRUD functionality via a BANano and SQL Server BackEnd. Usage. 1. Update the connection settings in msconnect.php to your database. Add this to the Files tab of your BANano project. 2. Include the attached class to your...

Ola Download BANanoWebix Things Copy the 1.Libraries contents to your external b4j libraries folder. The project source code for this lesson is in BANanoWebixMultiPage Part 5 here closes this tutorial. This encompasses everything we have learned from Part 1 to Part 4 and some more. 1. We...

Ola Download BANanoWebix Things The project source code is on the BANanoWebixMultiPage folder. Ensure to update the external libraries folder for b4j with contents of the 1. Libraries folder. Part 3 of our lesson looked at the addition of the grid and forms for both cities and positions of...

Ola Part 1 This is part 2 of our App Creation Process. We focus on the backend to store our data. The first backend we will look at is BANanoSQL, then BANanoSQLite & BANanoMySQL. The last two use inline PHP methodology. In lesson 1 we created our UI, a form named 'form' with 4 textboxes named...

Good day UPDATE 2020-05-19: Please use this library instead The attached class will help you in creating basic sql statements for CRUD functionality using BANanoSQL. We feature CREATE, UPDATE, UPDATE & DELETE statements, we also have added, creating a table. Whilst this class will work...

Ola UPDATE 2020-05-19: Please use this library instead Update: BANanoSQLite1 Example If you are opting for MySQL connectivity, BANanoMySQL is available here. My journey finally has led me to complete a basic wrapper that one can use for PHP SQLite access. Initially, we tried...

Ola Creating this demo app has has been done in 2 phases. The first phase has been to develop the components to use with the app into a BANano based library and secondly to build the resulting CRUD app using those components. The elements / components are HTML based elements (built as class...

Hi there... Anyway, this should not be long. Many moons I was requested to work on a firebase wrap for ABM. Im not there yet, but this should be a start. I'm still getting a hang of it and more will follow as I make more progress. I'm testing this for something I'm doing, however you can use...

Hi: I'm thinking in develop a simple product, that will need some data and the possibility of make reports and charts with such data. I think in SQLite for a simple way that permit package the app and database in a single installer and then the user can install it easily with not much hassle...