mysql

Hello, I'm facing a big problem with an app developed in B4A already on production, that is driving me crazy. The problem started this morning with no reason. I was working yesterday and sent an update to customer to check everything was ok before upload it to google play. until this morning...

Hello. I'm writing an app that allows several computers to add new orders to the database. To avoid any conflicts, I want to make sure that when one system is adding a new list of orders, no others can interrupt and will have to wait for the first one to finish up. I understand that the most...

I am using the version of b4a 5.80 My code Sub Process_Globals Dim mh1 As MysqlHandler Dim rs1 As ResultSet End Sub Sub conectar mh1.Initialize("50.62.161.40", "database", "usuario", "password") If mh1.isConnected= False Then...

Before you start: You need some experience with php, Apache Servers, OkHttpUtils, Lists, Maps and JSON structures. This is an updated example of how to - communicate with a apache server via OKHttpUtils calling a php script - doing MySQL data requests (Insert, Update and Delete) using...

Hola a todos: Estoy empezando a full con B4X... ya hice 3 cursos, y la verdad es que vá de pelos !!... Y en cuanto al pedido este, nunca me animé a registrarme y pedir ayuda... No sé, como que pensé que no me darían mucha bola... (perdón por la expresión :) ) Dispongo de un foro, hecho en php...

Hola a todos, espero se encuentre bien. Quisiera solicitar colaboración para lo siguiente. Estoy trabajando en B4A V7 y funciona muy bien, trabajando con base de datos de mysql a través del PHP en hosting de godaddy. Por otro lado, el caso es que, en hosting diferentes, como el AWS y el de...

Hi everyone. I developed an application that accesses MySql remotely. The provider (Hostgator) sent me an alert saying that I am sending too many requests to the database. The log of requests they sent me does not help much: I'm guessing that may be the way I'm accessing the database. Is...

After (unfortunately) having write many functions (in a code module in my b4j server project) which access a MySql, I remembered a fundamental rule: use Try-Catch when accessing external resources. So I thought to change all the functions that access the DB (and unfortunately all the calls to...

Hi Guys, Looking to have my app read the contents of a delimited text file and update a MySql table with that data. I have had a look around and was wondering if anyone had any examples or has done something similar they would like to share around best practices etc? Thanks

Hii Expert I want to make app that download data from mysql and insert it into android db file. Plz give me example or sample code. I am new in B4A

I did not know it; It seems very useful. http://sqlfiddle.com/#!9/7137c/1

Hello, my Problem is, i use firebase push (send push messages, subscribe to topics, unsubscribe) and this must act with my database (MySQL)... Currently I'm doing this in a SQL Trigger, where I call a B4J script, but the problem is that it can come that I need to call 3 scripts in a trigger...

I want to connect to a Mysql Database over the Internet. In B4a it is no problem with the mysql library. But how it works in b4i?

I can write in vb.net and b4a and have a vb.net app which creates a Mysql hosted online. I want to be able to read that Mysql and get records from vb but NOT from b4a. I want to read the mysql from my ANDROID app I have asked an indian developers to write a class so i can attach to my Android...

Hi all I'm trying to dynamically create a number of tabs based on content from a SQLLite database. These tabs are then populated with data into XUI customlistviews and where I attempt to lazy load as per Erels guide here Rather than hard code and use multiple designer created clvs and events...

Hi All, I have a field in a mysql table which gives the result like "1517191800" How can I display this as the correct time. (Around 1pm on 29th Jan 2018) Timezone is +11 hrs (10 + daylightsaving) (Hobart, Australia) Tom

This Tutorial save you a lot of time and is an Important Feature for Remote Database Apps! Integrated in this Turtorial: -install udf_sys on MySQL (Ubutnu 16.04) -call B4J Script (.jar) over MySQL Trigger -example for a Trigger that call this script -example for a B4J script (Firebase Push...