[chargeable] MSMySQL - Yet another MySQL-Library (but a FAST one :-))

benji · Apr 27, 2015

when i have for example...

dbADM.QueryASync2("Select id from apertura")

the procedure not raise immediately, first finish the sub and then raise the "Sub ADMDamir_QueryResult2"
there are some way to raise immediately?
i need to set the flag, with the query...

this is my code...

B4X:

Sub btnAceptar_Click
   
    dbADM.QueryASync2("Select id from apertura")
   
    If BooApertura = False Then
        ToastMessageShow("Horario Aperturado",False)
    Else
        ToastMessageShow("Ok para Apertura",False)
    End If
   
   
   
End Sub
Sub btnSalir_Click
    Activity.Finish
End Sub

Sub ADMDamir_QueryResult2(data As List, meta As Map)
    If meta <> Null Then
        BooApertura = True
        Msgbox("Listo para Apertura","Apertura")
    Else
        BooApertura = False
        Msgbox("Ya existe","Query")
    End If

End Sub

DonManfred · Apr 27, 2015

benji said:
there are some way to raise immediately?

No. All Async methods are asyncronous.

benji · Apr 27, 2015

Thanks

DonManfred · Apr 28, 2015

Do you need it badly?

Please note that a sync call will block your mainthread while executing. It is not the suggested way.

benji · Apr 28, 2015

i didn't think in that, but i found another way.

benji · Apr 28, 2015

sometimes, if i have this

B4X:

dbADM.QueryASync2("Select id from apertura where maquina = " & spMaquina.SelectedItem & " and Estado = 'Abierto';")

i take the control whit this

B4X:

auxcount = meta.Get("RecordCount")

then, if i have 0 in RecordCount the result is empty, but sometimes i have null like answer, why? any idea?

benji · Apr 29, 2015

benji said:
sometimes, if i have this

B4X:

dbADM.QueryASync2("Select id from apertura where maquina = " & spMaquina.SelectedItem & " and Estado = 'Abierto';")

i have records with this select, but now come empty, 1

benji said:
sometimes, if i have this

B4X:

dbADM.QueryASync2("Select id from apertura where maquina = " & spMaquina.SelectedItem & " and Estado = 'Abierto';")

i take the control whit this

B4X:

auxcount = meta.Get("RecordCount")

then, if i have 0 in RecordCount the result is empty, but sometimes i have null like answer, why? any idea?

i change the library for MSMaria and now works fine...

MarcoRome · May 6, 2015

Hi DonManfred.
Your library can solve this problem:

org.apache.http.conn.ConnectTimeoutException

Thank you

DonManfred · May 6, 2015

It is a network problem. Cannot be solved within a library.
But you should get an update on the status event and react on yourself... Try to Connect again

ruy · May 11, 2015

I just got the libraries and am trying to test the example in "MySQLExample.zip" but get the error:

B4A version 4.30
Parsing code. 0.03
Compiling code. Error
Error compiling program.
Error description: Missing parameter.
Occurred on line: 39
db.QueryASync("select * from b4alog ORDER BY log_id ASC;",)
Word: ,

What is the missing parameter "Task"?

DonManfred · May 11, 2015

It it a name you can give to this "task". You´ll get this "task" as part of the result meta data to identify the result. Can be helpful when using different queries.

ruy · May 11, 2015

DonManfred said:
It it a name you can give to this "task". You´ll get this "task" as part of the result meta data to identify the result. Can be helpful when using different queries.

How come it is not in the example code? Is this code incomplete, or it is supossed to be a running example? or am I missing something?

DonManfred · May 11, 2015

ruy said:
How come it is not in the example code?

The library has changed after the creation of the example but the example did not get an update.
I´ll update the Example soon to supress "problems like you posted"

ruy · May 11, 2015

I am new at B4A and I would really appreciate a fully working example (maybe the source code of "MySQL_Northwind.apk") will be very helpful. I find a little confusing some of the terms.

DonManfred · May 11, 2015

You can find the Northwind Database for example here. Download and import it to your database.

Please find attached the Northwind-Example-Source. Dont expext much code; it isn´t much

ruy · May 16, 2015

I am newbie with B4A as well as with MSMySQL. In my first attempt to connect I have succeeded but only in the debug mode. It works fine but, when I go into the release it is not connecting to the database. I get a message:

An error has occurred in sub:sync_mysql_queryresult (java line:436)
java.lang.NullPointerException

I can see in the Debug log "MySQL not connected!"

What is it that I am missing, because it connects in debug but not in release?

DonManfred · May 16, 2015

Have you added Internet permission to the Manifest?

Peter Simpson · May 16, 2015

Manifest line to add

B4X:

AddPermission(android.permission.INTERNET)

ruy · May 16, 2015

Thanks. I wrongly assumed it was added when the library was added. :-(

DonManfred · May 18, 2015

ruy said:
I wrongly assumed it was added when the library was added.

Maybe a good idea for future updates

[chargeable] MSMySQL - Yet another MySQL-Library (but a FAST one :-))

Active Member

Expert

Active Member

Expert

Active Member

Active Member

Active Member

Expert

Expert

Member

Expert

Member

Expert

Member

Expert

Attachments

Member

Expert

Expert

Member

Expert

Privacy & Transparency

Privacy & Transparency