Search Results

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 to connect to the database located on a server (I am working on a version for b4i, but it is only obtainabl
link: Update. Completed the MySql connector written entirely in B4X. Tried with all types and with different tables and databases. It seems to work correct
link: Initialize(Me,"MYSQL") MYSQL2.Connect("com.mysql.jdbc.Driver", $"jdbc:mysql://${Main.Configuracion_Red.serv}:${Main.Configuracion_Red.port}/${Main
link: Work has started on the MySQL connector for iOS.... Anyone interested?

PopolateListTwoLine("mysql.db","mytable","City","State","ID", "", ListView1,True) PopulateListTwoLineBitmap (FileNameDB As String, NameTable As String, FieldName As String, FieldSecondLine As String, FieldID As String, FieldBitmap As String, Condition As String, LV As ListView, CLearListView As Bool

GetBlob is not supported for now... I'm currently working on it. I'm attaching the project for B4J & B4A And The source code too. I don't know if it is compatible with B4I. IMPORTANT : This library is BETA, it seems sometimes, you will find some bugs, if you find one, please report it and start a

'Run the procedure 'proctest is the sub for general error capture reporting MySQLConnection.ExecProcedure("proctest",MYSQLProcedure) Finally run the procedure. A general sub stub is used for error reporting. In this case "proctest_error". Result sets are returned as memory backed Android cursors
link: Try this in your activity resume Activity resume. I assume MySql is declared in Process_Globals? Sub Activity_Resume SettingsLoad MySql. = N
link: Thank you to this library.I sure it is the best
link: A MySQL lib with 100% support for Stored Procedures too. Thank you for this lib. Regards Anser

?Usage Instructions: 1. Upload the api.php file to your server. 2. Edit the header with your connection data. 3. You're ready to communicate your app with your mobile and desktop applications. Note: The API works fine without the library, but the library will help you communicate more easily. ? E
link: Currently, this library is designed specifically for MySQL.
link: will it support https/ssl in the php rest api url?
link: Take advantage and get a 30% discount on any product throughout this month with the code STORECODE30

Updated 2018-08-16. Please note there are breaking changes to the new version of the library (SQLCallPRoc Version 1-10.zip) so it will work correctly with the Microsoft JDBC Driver. The sample for MYSQL has changed and there is a new sample for MS SQL Server. See post #5 for why the change was neces
link: See first post for MSSQL sample and new version of the library. There was actually an issue with using the original library with MSSQL. The problem i
link: Hi KeirS I was asking if the above will work for MsSQL, but I guess I got my answer after changing the syntax to "exec StoredProcedureToCall ?, ?, ?
link: That's the case with Mariadb, Mysql... With Oracle ( which i'm using ) i can return a cursor... Actually i need to return a cursor if need to call F

I've been working a lot in MySQL lately and got fed up creating layouts that were very similar to show audit reports. I came up with this which is a designer script extension that loads however many labels you specify into a pane. You can define the widths, left margin and EventNames for the label

MySQL connector: https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.34.tar.gz MS SQL: http://jtds.sourceforge.net/ As we are connecting to a remote database, all requests must be asynchronous. It is quite simple to make asynchronous requests with the resumable subs feature: S
link: Not quite understand what changes should be made if I want to connect to a MSSQL #AdditionalJar: jtds-1.3.1 Public mysql As JdbcSQL Private
link: SQLite is not really a client server database such as PostgreSQL, MySQL, MSSql, etc. It is a local datastore that can be queried via SQL. The only way
link: Dear Forum I was trying to create a table with mysql jdbc driver but get the following error: (MySQLSyntaxErrorException) com.mysql.jdbc.exceptions.j

MiniORMUtils Version: 2.50 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). Project Template: MiniORM GitHub: https://github.com/pyhoon/MiniORMUtils-B4X Older
link: Migration from version 1.x DatabaseConnector is now ORMConnector ORMConnector requires a ConnectionInfo object to pass as a parameter for initializat

This means that I will not be dwelling much on the UX here but just the functionality for CRUD for inline php. I am using my own developed UOENow library for this and will make the 'free' components version available soon. The professional version of Creative Tim's Now UI Kit Pro is not distributabl
link: End If The mysql.Insert method builds up the sql command, the args, the command and the types as indicated on post 1 and returns this as a JSON strin
link: Put("c", "2") mysql.ResetTypes mysql.AddIntegers(Array("id","c")) Dim rsnew1 As MySQLResultSet1 = mysql.Insert("test", nr2) rsnew1.res
link: STEP 3 Update the BANano initialization settings for php to your own. BANano.PHP_NAME = "bananomysqldemo.php" 'for release use actual path of we

Powered by ColBERT