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

[DonManfred]

Debug true = some more log output especially in initialisation-phase

UseStrictMode should be true when you are using the lib directly in a activity. UseStrictMode enables the app to use networktraffic on mainthread.

Usually the lib should be used from a service to bypass the need of UseStrictMode

 

[maurizio barbera]

thank's

 

[MarcoRome]

Hi Don. Hi All.
Is it possibile import Value that i have in a List in MySql with your library ?
Example i use this if i want import List in SQLite:

Dim lst1 As List
lst1 = su.LoadCSV(fd.FilePath, fd.ChosenName,";")
        Try
            For i = 1 To lst1.Size - 1
               Dim sColumn() As String
               sColumn = lst1.Get(i)
               'This is in SQLite
               'db.ExecNonQuery2("INSERT INTO fl (bl_id, fl_id, description) VALUES (?, ?, ?)", sColumn)
   
            Next

        Catch
       
        End Try

Thanks Don
Bye
Marco

 

[maurizio barbera]

Hi, you can use this command

• PeparedStatement (sql As String)
  
• SetPeparedBlob (parameterIndex As Int, imagepath As String)
• SetPeparedInt (parameterIndex As Int, x As Int)
• SetPeparedLong (parameterIndex As Int, x As Long)
• SetPeparedString (parameterIndex As Int, x As String)
• ExecutePeparedStatement

PeparedStatement("INSERT INTO fl (bl_id, fl_id, description) VALUES (?, ?, ?)")
setpeparedstring (0, "string to insert in bl_id")
setpeparedstring (1, "string to insert in fl_id")
setpeparedstring (2, "string to insert in description")
executepeparedstatement

 

[Luis Carrillo Escalona]

I already made my donation, as under the library, thanks

 

[DonManfred]

Mail send with link

 

[Mandrake]

Hi DonManfred, I just bought the liberia I think you got me .

A query for other applications a PHP file used to work with the web server, where calls that php file or files.

 

[DonManfred]

A query for other applications a PHP file used to work with the web server, where calls that php file or files.

If this is a question then you forgot the questionmark. Additional i do not understand the question.

 

[Mandrake]

Hi Don Manfred donate $ 5 by the library can send the library, thanks

 

[Luis Carrillo Escalona]

as forcing event execution when executing mysql_query Result QueryASync because soguientes execute commands without going to this event, thanks

 

[DonManfred]

I did not understand the question

 

[Luis Carrillo Escalona]

the problem is that does not enter the event after executing mysql_query Result QueryASync, there is a way to force or under what conditions runs

 

[DonManfred]

did you watch the status event? Does the lib connect to the database successfully?

 

[Luis Carrillo Escalona]

with next code, i need return variable of type output for identity value
db.PeparedStatement("{call forestal_Antares.p_respuesta_ins(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}")
db.SetPeparedString(1, s_doc)
db.SetPeparedString(2, s_eval)
db.SetPeparedString(3, s_Fecha)
db.SetPeparedString(4, s_faena)
db.SetPeparedString(5, s_pred)
db.SetPeparedString(6, s_oper)
db.SetPeparedString(7, s_maq)
db.SetPeparedString(8, s_pieza)
db.SetPeparedString(9, s_jef)
db.SetPeparedString(10, s_ValGPS)
db.SetPeparedString(11, XML_ws)
db.ExecutePeparedStatement

 

[DonManfred]

with next code, i need return variable of type output for identity value

preparedstatement is to INSERT, UPDATE or DELTE records. Is is not able to give resultsets

With your parameters seen i think you should use a normal query.

Additional i dont know what {call} will do?

 

[benji]

DonManfred, do you know some library like this to connect to Oracle?
Only i see RDC or WebServer

 

[DonManfred]

DonManfred, do you know some library like this to connect to Oracle?

Sorry i dont know any.

 

[Luis Carrillo Escalona]

if I run 6 QueryASync, as when they finish processing all. Is there any event or any event B4A

 

[DonManfred]

if I run 6 QueryASync, as when they finish processing all. Is there any event or any event B4A

Yes, the result-event will be raised 6 times

 

[taufik adi sanjaya]

Hi Don Manfred donate $ 5 by the library can send the library from avktech

thanks