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

[RandomCoder]

The link will be sure to follow soon, just bare in mind that we're all in different time zones. Manfred may have decided to have an early night

 

[benji]

You are right. There was an error in both msMySQL and msMariaDB libs. Will update new version in a few minutes on my Dropbox folder

Thanks very much, it's work.

 

[jahswant]

Can you share with us your NorthWind B4A Project..?
Edited : Saw it
Not having it working...
Can you share with us your NorthWind B4A Project..?

 

[benji]

how i know if the executebatch is ok or wrong?

i try to use this

Sub MySQL_BatchResult(batch As Map)
    Log(batch)
End Sub

but i have this error "java.lang.Exception: Sub mysql_batchresult signature does not match expected signature."

any help is appreciated, thanks in advance.

 

[DonManfred]

The signature has changed:
Use this please

Sub MySQL_BatchResult(data As List, meta As Map)
    'Log("MySQL_BatchResult()")
    'Log("Time: "&meta.Get("ms")&"ms")
    'Log("Size: "&meta.Get("size"))
    'For i=0 To data.Size-1
        'Log(i&"="&data.Get(i))
    'Next   
End Sub

 

[jahswant]

@DonManfred please update first post

 

[Peter Simpson]

Hiya @benji,

how i know if the executebatch is ok or wrong?

Replace this:

Sub MySQL_BatchResult(batch AsMap)

With this:

Sub MySQL_BatchResult(data AsList, meta AsMap)

Also check the database afterwards...

 

[benji]

The signature has changed:
Use this please

Sub MySQL_BatchResult(data As List, meta As Map)
    'Log("MySQL_BatchResult()")
    'Log("Time: "&meta.Get("ms")&"ms")
    'Log("Size: "&meta.Get("size"))
    'For i=0 To data.Size-1
        'Log(i&"="&data.Get(i))
    'Next  
End Sub

works perfectly, thanks.

 

[tango]

• • The library is not free. You need to donate as low as 5$ to get the library.

[/QUOTE]

Hi DonManfred ,
i paid price and how can i get library?

 

[RandomCoder]

Manfred will send it as soon as he's next online (not long normally), the system is not automatic he has to send it personally.

 

[DonManfred]

i paid price and how can i get library?

Can you post me Paypal Transactionid and when you paid?
Please provide the email from which you paid so i can check it then.

Send a personal message if you want.

 

[Peter Simpson]

Patients @tango,
Manfred is a very busy person. He is probably having a shave right now

 

[DonManfred]

Manfred will send it as soon as he's next online (not long normally), the system is not automatic he has to send it personally.

i got a registration this night at 1am. I send the mail one hour ago.

I got another registration today at 12am and send the mail at 12:12

If there are any missing registration then it seems i´m missing a mail from PayPal.

Anyway; it is hard to check without knowing a name, a email

 

[DonManfred]

Seems like tango was the registration at 12am

 

[Peter Simpson]

What 12am when you were fast asleep???

 

[DonManfred]

damned 12h times...

12 highnoon. 12:00 on a 24h clock

41 minutes ago

 

[tango]

why we use DISABLESTRICKMODE?

 

[DonManfred]

Because the connection is handled on the main-thread.
Querying results will run in an background-thread

 

[tango]

hi DonMafred,
i examine that check_connection2 stops app until connection is ok. if connection is ok then it gives "true", but if i cut connection, it waits antil connection came back and during this times it stops app. how can can i control if no connection in small time

 

[Peter Simpson]

@tango try this, but I don't know. I'm probably reading your question incorrectly...

'Maybe something like this in Activity_Resume will help, but I'm just guessing as I don't have the same issue as you are having.
Sub Activity_Resume
    MySQLExe.check_connection
    MySQLExe.QueryASync2(....)
End Sub

Sub Activity_Pause (UserClosed As Boolean)
    MySQLExe.CloseDatabase
End Sub