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

vbmundo

Well-Known Member
Licensed User
Hi Don,

I have 2 questions about Status Sub

Sub xxx_Status(Connected as boolean, ReConnecting as boolean, RetriesLeft as int)

When this SUB is executed ?

And.. what kind of code you must insert there ? I mean, what's the best practise about this SUB ?

Regards
 

DonManfred

Expert
Licensed User
Longtime User

DonManfred

Expert
Licensed User
Longtime User
but the STATUS SUB must be in every Activity
this is because of what?

 
Last edited:

vbmundo

Well-Known Member
Licensed User
Because I can't put the QUERYRESULT in a Service., because I need the Field values and results to fill Views. you can't reference a View or Layout or Activity from a Services.
 

vbmundo

Well-Known Member
Licensed User
get the result in the service and then call a sub in your activity (giving the result as parameter) from the qryresult sub. In the called sub you then can do the UI changes.
It's not the best practice.

Please look how MariaDB Keirs Lib works... I mean that is the best architecture..

Of course, your lib is fastest and I choice yours, but you must reconsider some changes in the structure
 

keirS

Well-Known Member
Licensed User
Longtime User
It's not the best practice.

Please look how MariaDB Keirs Lib works... I mean that is the best architecture..

Of course, your lib is fastest and I choice yours, but you must reconsider some changes in the structure

What DonMannfred describes is best practice. It's exactly what I would recommend when using my library.
 

MohammadNew

Active Member
Licensed User
Longtime User
Hello DonManFred , I used your library v 1.0.9

but give me error

' Create a NEW record based on the inputvalues
Dim qry As String
qry = "INSERT INTO tpl2 SET tpl1a1=?, imgname=?, img=?, id=?"
db.PeparedStatement(qry)
db.SetPeparedString(1,EditText1.Text)
db.SetPeparedString(2,EditText2.Text)
db.setPeparedBytes(3,buffer)
db.setPeparedInt(4,txtID.Text)
db.ExecutePeparedStatement

the error (Missing Parameter)
 
Cookies are required to use this site. You must accept them to continue using the site. Learn more…