B4A Tutorial SQL tutorial - Erel    Oct 2, 2019   (19 reactions)   tags: sqliteimages, begin transaction, SQL methods: SQL with Wait For
The following tutorial is obsolete:
This tutorial covers the SQL library and its usage with Basic4android.
There are many general SQL tutorials that cover the actual SQL... B4A Tutorial Connect Android to MySQL Database Tutorial - Erel    Sep 20, 2018   (29 reactions) it is a MySQL database.
A tutorial for connecting to SQL Server is available here.
Android cannot connect...A new more powerful framework is now available: jRDC2.
This tutorial explains the basic concepts... B4J Tutorial SQL Tutorial - Erel    Dec 8, 2013   (5 reactions) B4J jSQL library is similar to Basic4android SQL library.
This tutorial will cover the differences.../android/forum/threads/sql-tutorial.6736/#content
jSQL library is not tied to any specific SQL engine... B4A Tutorial [B4X] B4XTable - Load data from SQL database - Erel    Feb 10, 2019   (34 reactions)   tags: b4xtable B4XTable.SetData expects a List where each entry in the list is an array of objects with the data of a single row. The data can come from any source you like. https://www.b4x.com/basic4android/images/SS-2019-02-10_15.49.29.png Example of loading the data from a SQL database: B4XTable1.AddColumn....Initialize Dim rs As ResultSet = sql.ExecQuery("SELECT CustomerId, FirstName, LastName... the Data list with the data coming from the SQL db. Step #3: call B4XTable.SetData. B4A project... B4J Code Snippet [B4X] MiniORMUtils - SQL Query Builder - aeric    Apr 21, 2024   (18 reactions) MiniORMUtils Version: 1.10 Demo Version: 1.03 This library can be use for creating db schema and performing CRUD operations. It is suitable for Web API Template or any database system. Currently it supports SQLite and MySQL (B4J). A B4XPages Demo project attached. It is a modified app from Web API Client but use local SQLite. For B4J, it can be modified to connect to MySQL database. Initialization Dim MDB As MiniORM MDB.Initialize(Main.DBOpen, Main.DBEngine) MDB.UseTimestamps = True MDB... B4A Tutorial [B4X] SQL with Wait For - Erel    May 15, 2017   (21 reactions)   tags: wait, Wait For, Resumable Sub, SQL Wait For progress web, SQL . The new standard way to insert data is: For i = 1 To 1000 sql.AddNonQueryToBatch("INSERT INTO table1 VALUES (?)", Array(Rnd(0, 100000))) Next Dim SenderFilter As Object = sql.ExecNonQueryBatch("SQL") Wait For (SenderFilter) SQL_NonQueryComplete (Success As Boolean) Log... will be caught by the correct Wait For call in all cases. - Note that SQL.ExecNonQueryBatch begins... therefore be issued synchronously with SQL.ExecQuery2. However if there is a slow query then you should... B4J Code Snippet [Project Template] jRDC2 Server (SQLite, MySQL, MS SQL, Firebird, Postgresql, DBF) - aeric    Jan 11, 2024   (16 reactions) jRDC2 Server Template Version: 1.12 (based on jRDC2 version 2.23) Create a new project and run it! To be accompanied with jRDC2 Client Template Introduction: To be edited 147014 Version 1.00 : 9KB Version 1.11 : 127KB Version 1.12 : 127KB Version 2.00 (beta) : 127KB Note: If you think the latest version is big, you can use version 1.00 otherwise you can remove the images inside www/img or us... B4A Tutorial Connect Android to MS SQL Server Tutorial - Erel    Jun 27, 2016   (8 reactions) A new more powerful framework is now available: Remote Database Connector.
This tutorial is a follow up to the previous tutorial that explained how to connect to a MySQL database using a PHP web service. This time we will use an ASP.NET web service to connect to a Microsoft SQL Server.
Android... a "read-only" user will protect this attack.
In this tutorial I will post the ASP.NET script... B4J Code Snippet [SQL] DButils v.2.5 for SQLite and MySQL - peacemaker    Oct 11, 2023   (4 reactions) classes), but MySQL also, due to big size that now is more convenient to see via web-browser... DButils2 from Erel: https://www.b4x.com/android/forum/threads/b4x-dbutils-2.81280 module with MySQL... to switch the db type (SQLite or MySQL) during usage: 'MySQL additions: 'Added to give EscapeField more flexibility Public Sub SetEscapeChars(MySQL As Boolean) If MySQL Then escapeCharStart = "`" escapeCharEnd = "`" isMySQL = True Else... B4A Tutorial For beginners: How to communicate with a server using httputils2 (Part 2: MySql) - KMatle    Jun 4, 2018   (18 reactions) 're ready to do some MySql stuff First we must create a table. Assuming we have a hosted website wth php and MySql there is a admin tool (see documentation of your hoster) to create databases and.... Connecting to MySql Edit your script again. First we have to connect to our database: <? $host... Page: 1   2   3   4   5   6   7   |