Search Results

Update 2018: New video tutorial: 263187269 The source code is available here: https://www.b4x.com/android/forum/threads/b4x-erel-teaches-programming-video-tutorials.88787/page-2#post-577932 Async 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 language. If you are not familiar with SQL it is recommended to start with such a tutorial. SQL...

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...
link: Can you pos the error as appears in the log in a new thread please the error message is just: unau...
link: When trying to access there is an error message: unauthorized, how do I fix it ?, thx Please start...
link: Can you pos the error as appears in the log in a new thread please...

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. jSQL wraps Java JDBC mechanism and allows you to access any type of SQL database. Including remote... to add the jar to the package. For example to connect to a MySQL database: #Region Project...
link: Dieses Tutorial behandelt die SQL Library und ihre Nutzung mit Basic4android. Es gibt viele...

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

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

Updates jRDC2 Server v2 is available 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 yo...

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...
link: NWs I am an absolute beginner of android devolopment now i need to connect sql server to...

The modes are explained here: https://www.sqlite.org/pragma.html#pragma_journal_mode The two cases where it is important to set the journal mode: 1. WAL - B4J server solutions: https://www.b4x.com/android/forum/threads/webapp-concurrent-access-to-sqlite-databases.39904/#content 2. DELETE - when it is important that the database will be made of a single file. sql.ExecQuerySingleResult("PRAGMA journal_mode = delete") Log("Current mode: " & sql.ExecQuerySingleResult...

attached a sql file to import in your database. The database name will be B4X. - B4J to create the jRDC2... when this post have been write) Steps: - Import the sql file to you database. You can use phpMyAdmin, HeidiSQL, etc… - Configure jRDC2 server. Open the attached B4J file and change your user and... as md5) sql.Login = SELECT * FROM B4X.users WHERE `username` = ? AND `password` = md5(?) sql.getEvents = SELECT * FROM B4X.events WHERE `month` = ? AND `id_user` = ? sql.updateEvents = UPDATE...

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