Search Results

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...
link: Please start a new thread in the questions forum and provide more information about the database tha...
link: : sql7.freemysqlhosting.net;user=sqluser;password=passw #AdditionalJar: mysql-connector-java-5.1.39-bin...
link: Why are you using jtds if it is a MySQL database? See the code from the first post....

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

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

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

(PocketBase) and also a new version using Secure Api Key MySQL REST API. When developing webapps, one... This webapp helps you learn how to use MySQL REST API using a secure Api Key, this you can deploy shared... these applications is that they share 99.99% code. Really? Yes. Let me explain 1. In the MySQL REST API example... the MySQL REST API example, the connection string is https://localhost/sdvetmysqlapi vs the PocketBase...
link: (PocketBase) and also a new version using Secure Api Key MySQL REST API. When developing webapps, one...

copying is needed any time when changed data. Server database like MySQL, MariaDB can be explored... installed, configured, db user rights and user privileges done... MySQL needs JDBC driver connector... tool, like Adminer https://www.adminer.org/ that supports SQLite db as well as default MySQL one. And... version 4.8.1 (can be updated from the project web-site), used for access to MySQL or other web-base...

BANanoSQL makes it possible to use 'normal' SQL queries on the IndexedDB database located in the browser. There are three ways on how to work with BANanoSQL: 1. Event Driven... guide the process. Advantage: it can raise an Error Event in case e.g. an SQL is malformed.... Sub BANano_Ready() SQL.Open("SQL", "bananodb") End Sub Sub SQL_SQLOpened() SQL.Execute("CREATE TABLE IF NOT EXISTS flights (flightNo INT, fromCity STRING, toCity...

to row-based used by MySQL, SQLLite and others. This makes it superfast in retrieval of column data for analytical purposes such as summary statistics. DuckDB provides a rich SQL dialect with advanced... DuckDB uses SQL syntax, I wondered if it would work with the B4X SQL library. And it does, out..., include standard libraries: DBUtils and jSQL These are B4J examples. I have not tested it with B4A. Since... 'In Gobals Sub: ' Private SQL As SQL ' Private dbPath As String = File.DirApp &...