Android Question [SOLVED] MSMariaDB/MSMySQL Open 2 tables same time

[Magma]

Hi there...

I just wanna answer if i want to open 2 tables of a database the same time i must use this:

    Dim db As MSMaria
    Dim db2 As MSMaria

and must open the db two times / initialize it... and use different subs/events for every table ?

Or there is a better way ?

 

[DonManfred]

andopen the db two times

Why you need to open it multiple times?

 

[Magma]

I want to use 2 tables at my app but when trying to open second with the same "db" getting error.

    db.Initialize("MySQL","192.168.168.3:3306","root","mypass","mydb")

   
    db.QueryASync("select * from products;","show1")
    db.QueryASync("select * from history;","history")

 

[DonManfred]

Call both querys with the same connector. No need for a second connection

 

[Magma]

The example above must work - if it is the same table ?

 

[Magma]

WORKED - after restarting Mariadb Server... don't know what exactly was the problem. but thanks again!