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

Magma

Well-Known Member
Licensed User
Hi there...

I just wanna answer if i want to open 2 tables of a database the same time i must use this:
B4X:
    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

Expert
Licensed User
Upvote 0

Magma

Well-Known Member
Licensed User
I want to use 2 tables at my app but when trying to open second with the same "db" getting error.

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

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

Magma

Well-Known Member
Licensed User
The example above must work - if it is the same table ?
 
Upvote 0

Magma

Well-Known Member
Licensed User
WORKED - after restarting Mariadb Server... don't know what exactly was the problem. but thanks again!
 
Upvote 0
Top