Search Results

DBQuery is a thin wrapper around the platforms' SQL libraries: SQL, iSQL and jSQL. Features: A simpler and more coherent API. It fixes several issues in the original libraries, which date back to B4A v1.0. The most notorious one is SQL.ExecQuerySingleResult returning Null as a string result... B4A and B4i it works with SQLite. In B4J it works with any type of database. The wrapped SQL object...? Initialize the SQL object as usual and then initialize DBQuery. sql1.Initialize(xui.DefaultFolder, DBFile...

This is a port of B4J jSQL library. The SQL type was renamed to JdbcSQL and ResultSet was renamed to JdbcResultSet, this allows using it together with the SQL library. SQL library - local SQLite databases. JdbcSQL - Any remote SQL database with a supported JDBC driver. MySQL and MS SQL.... As explained in the jSQL tutorial, you need to copy the jdbc jar to the additional libraries folder...-bin Note that you should use Java 7 jars. MySQL connector: https://dev.mysql.com/get/Downloads...

). SQL library already exists for B4J and it would not be necessary to create a new library. But to... on the internal SQL library. It is written entirely in B4X You can use it to access DataBases that allow direct...Based on @Peter Simpson's code (here), I developed a library that allows you to connect directly to MySql, MsSql (for the moment) databases with B4A and B4J. To be clear, you don't need JRDC... services that allow access only through PHP or ASP NOTE: You can use this library for personal and...

SqlCipher a SqlCipherB4A (nombre de la clase). En el envoltorio, Erel extiende la clase SQLCipher de SQL. Yo eliminé esa extensión. Adjunto los archivos (.aar) y las librerías. Hello, due to the issues I encountered with Google and SQLCipher, I decided to update the library to version 4.10.0.... I tested part of the library; the testing scope was Android 15 (real device). If you encounter issues.... I tried to keep the method names the same. I only changed SqlCipher to SqlCipherB4A (class name). In...

://run?File=%B4X%\Zipper.jar&Args=SQL.zip Sub Class_Globals Private Root As B4XView Private xui As XUI Dim DB As SQL End Sub Public Sub Initialize ' B4XPages.GetManager...) #If B4J xui.SetDataFolder("SQL") #End If If File.Exists(xui...
link: SQL.ExecQuery2 expects an array of strings not objects. You can see it in the method signature. ...
link: use Array As Object for ExecuteQuery2. https://www.b4x.com/android/forum/threads/sql-no-rows-in...

of the forum so I thought I would post a library which supports stored procedures with IN,OUT and INOUT... uses the sample database from www.MySQLTutorial.org. You need to download the MySQL Connector/J JDBC...
link: the connection. If you are not using stored procedures you should use Erel's library: https://www...
link: Hi Thanks for this Library I am edit database from Mysql then I need to add data to 2 Combobox...
link: A silly question, What is the difference between this library and "Asynchronous MariaDB/MySQL...

SQL library. Mainly the insert, update and delete convenience methods but also some additional...) 'Initalize SQLExtended object by using the reflection library to get the private db field of the SQL... ColumnValues in the library. The Reflection library is required to initialize the SQLExtended object...
link: ? I have added the inTransaction method to the library which will return true if the process it is called...
link: Hi keirS, today i had strange update problems in sqlite; when i updated a record and read back, the new version was ok; when i left ...

is yours. This library userfull 'in firm' applications. Because MySQL IPNumber should...Hello everyone, This is my second library very similiar to MSSQL. There are only three...
link: There is no good reason to use any library other than JdbcSQL....
link: Can this library support android:targetSdkVersion 29...
link: Sub sLekerdez(csql As String) As Int Dim mcc As List Dim mi As Boolean = False Main.mqre...

There are a couple of MySQL libraries already available. They all perform network functions.... I have tried to keep it as simple as possible so the function names mimic the B4A SQL library for...
link: but I do not know how to start with JdbcSQL. I would be very grateful if there is an example What...
link: Thanks for answering .. but I do not know how to start with JdbcSQL. I would be very grateful if...
link: Note that you can use JdbcSQL with this driver....

DBUtils is a b4xlib with useful utilities related to the SQL library. It is designed to work with SQLite databases. There have been three versions of DBUtils, one for each platform (except of B4R). DBUtils v2.0 merges the three modules to a single module that is compatible with B4A, B4i and... the clickable parameter. Instructions: put the library in the additional libraries folder. It depends on: SQL or jSQL or iSQL B4A also depends on RuntimePermissions. Updates: V2.11 - Fixed issue...