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

DonManfred

Expert
Licensed User
Longtime User
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
 

MarcoRome

Expert
Licensed User
Longtime User
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:
B4X: 
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
 
M

maurizio barbera

Member
Licensed User
Longtime User
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
 
M

Mandrake

Member
Licensed User
Longtime User

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.
 
M

Mandrake

Member
Licensed User
Longtime User
Hi Don Manfred donate $ 5 by the library can send the library, thanks
 
Last edited:
L

Luis Carrillo Escalona

Member
Licensed User
Longtime User
as forcing event execution when executing mysql_query Result QueryASync because soguientes execute commands without going to this event, thanks
 
L

Luis Carrillo Escalona

Member
Licensed User
Longtime User
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
 
L

Luis Carrillo Escalona

Member
Licensed User
Longtime User
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

Expert
Licensed User
Longtime User
Luis Carrillo Escalona said:
with next code, i need return variable of type output for identity value
Click to expand...
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?
 
B

benji

Active Member
Licensed User
Longtime User
DonManfred, do you know some library like this to connect to Oracle?
Only i see RDC or WebServer
 
You must log in or register to reply here.
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…