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

[vbmundo]

Use the IDE to create the sub for you!?

You mean

Sub MyTask_Error( ?? )

but what receive as parameter ? a String ? a Map ?

 

[DonManfred]

You mean

Sub MyTask_Error( ?? )

NO!

As i wrote earlier: use the ide to get the eventsubsignature...

 

[vbmundo]

NO!

As i wrote earlier: use the ide to get the eventsubsignature...

http://recordit.co/uN9F5yjVqK

aaah I see

It's new for me.. sorry

 

[vbmundo]

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]

When this SUB is executed ?

Whenever the status changes. connected, not connected

And.. what kind of code you must insert there ?

you must not... It is a infomative event.

It makes no sense to send a query if the status is not connected

 

[vbmundo]

It makes no sense to send a query if the status is not connected

You said the magic words...

because I recommend you add properties to your library.
For example., You do not have any way of asking if the connection was made or not, if the base is connected.

Thanks

 

[DonManfred]

You do not have any way of asking if the connection was made or not

once you get the status connected it is connected...
If you get the status not connected then it is not.
Store a global variable and you´ll always know

 

[vbmundo]

once you get the status connected it is connected...
If you get the status not connected then it is not.
Store a global variable and you´ll always know

Yes,

But you must include this _Status in every Activity, and this is not the best practice.

 

[DonManfred]

But you must include this _Status in every Activity, and this is not the best practice.

the best place for the lib and for the connection is a service. Only one status is needed to get a appglobal global variable

 

[vbmundo]

the best place for the lib and for the connection is a service. Only one status is needed to get a appglobal global variable

I have all Connections in Starter Service, but the STATUS SUB must be in every Activity

 

[DonManfred]

but the STATUS SUB must be in every Activity

this is because of what?

** Service (starter) Create **
** Service (starter) Start **
Raising.. mysql_status
Connected to Database
** Activity (main) Create, isFirst = true **
** Activity (main) Resume **
Activity_Resume()
Starter:MySQL_Status(true,false,0)
SqlException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'Descriptions' in 'field list'
lib:Raising.. mysql_onsqlerror()
Starter:MySQL_onSqlError((MyMap) {ErrorCode=1054, ColumnCount=0, RecordCount=0, TaskID=test, Exception=com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'Descriptions' in 'field list'})
Starter:MySQL_QueryResult(Columns 0, Records 0,nullms,test
Starter:MySQL_QueryResult(Columns 1, Records 8,160ms,test2
(MyMap) {My_Name=Soft drinks, coffees, teas, beers, and ales}
(MyMap) {My_Name=Sweet and savory sauces, relishes, spreads, and seasonings}
(MyMap) {My_Name=Desserts, candies, and sweet breads}
(MyMap) {My_Name=Cheeses}
(MyMap) {My_Name=Breads, crackers, pasta, and cereal}
(MyMap) {My_Name=Prepared meats}
(MyMap) {My_Name=Dried fruit and bean curd}
(MyMap) {My_Name=Seaweed and fish}
** Activity (main) Pause, UserClosed = false **
** Activity (main) Resume **
Activity_Resume()

 

[vbmundo]

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.

 

[DonManfred]

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.

 

[vbmundo]

You mean that from a Service you can call an Activity Sub ?

 

[DonManfred]

You mean that from a Service you can call an Activity Sub ?

CallSubDelayed(Main,"subname")
CallSubDelayed2(Main,"subname",parameter1)
CallSubDelayed3(Main,"subname",parameter1,parameter2)

 

[vbmundo]

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

 

[Luis Carrillo Escalona]

The other day I saw microsoft azure has also mysql, you can connect from this library?

 

[keirS]

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.

 

[DonManfred]

The other day I saw microsoft azure has also mysql, you can connect from this library?

I´m not sure. I have´nt tried. I have no azure database.
Most probably you need a connector for it to use it

 

[MohammadNew]

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)