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: Work has started on the MySQL connector for iOS.... Anyone interested?
link: Initialize(Me,"MYSQL") MYSQL2.Connect("com.mysql.jdbc.Driver", $"jdbc:mysql://${Main.Configuracion_Red.serv}:${Main.Configuracion_Red.port}/${Main

?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

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

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

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: Dear Forum I was trying to create a table with mysql jdbc driver but get the following error: (MySQLSyntaxErrorException) com.mysql.jdbc.exceptions.j
link: If supported by the JDBC driver and DB used, both sides can be configured for secure connection (no need for tunneling). That setup may be a pain and

this extension is deprecated as of PHP 5.5.0, Additionally you are suppressing any error.
link: Hi DonManfred is true...i change to: mysqli_connect the errors... i work in a new versions.... i want too put more sentences... (update....), now is r
link: Hi all i share a easy code to get select from a database using a file on server (can use https) the first part of code is php to put on server with n
link: Hello DonManfred, i see the MySQLi-Class and is good way to work with mysql. i'm try to use. thanks

so, there's something called server side events (SSE). it apparently has something to do with notifications from a web server to a browser. i'm guessing it's what happens when you see an annoying pop-up message from a web server asking persmission to send you notifications. good luck with that;

I created this report in very quick time this afternoon from my family history mySQL database. Mostly because I didn't have to create a layout, and could actually visualize the data while working on it. 824151648

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: Reproduction: I am using and testing this on XAMPP with MySQL, so obviously, one needs to create a DB.. STEP 1 'SQL Commands to run to create the s

Powered by ColBERT