Android Question MySql, I need get data

You need to explain in more detail what you are trying to do..

What is db.query? Code for that method?

Well for starters at line 196 in your "ATUAL" activity, you have:

There is no method "Query" in the database object. You should change it to:

Once you get past that, you can start to look at whatever other issues you might have.

- Colin.

No, he’s using this https://www.b4x.com/android/forum/threads/mssql-with-jdbc-library-v1-00.22244/
That library’s query method returns a list, not a result set. That explains the error message. @macerau , please read that library’s posting to see the proper use of its methods.

You should use JdbcSQL if you want to directly connect to a MS SQL database.

Peter Simpson said:

You need to explain in more detail what you are trying to do..

Click to expand...

Imagine a database with a table called "Mytab".
This table contains 2 records each record has two columns
ex: id name
01 Mary
02 John

Okay, what I need is to do a select on this table of type:
"select id, Name from MyTab"
is to put the table data in two variables of the type
dim id (2) as string
dim Nm (2) as string

in vb6 could be like this

id (1) = tb ("id")
Nm (1) = tb ("Name")
tb.movenext
id (2) = tb ("id")
Nm (2) = tb ("Name")

debug.print id(2)
02
debug.print Nm(2)
John

I would like this to work on b4a

Erel said:

You should use JdbcSQL if you want to directly connect to a MS SQL database.

Click to expand...

It may seem like bullshit but that's exactly what I want and I can not get somebody out of a light

Imagine a database with a table called "Mytab".
This table contains 2 records each record has two columns
ex: id name
01 Mary
02 John

Okay, what I need is to do a select on this table of type:
"select id, Name from MyTab"
is to put the table data in two variables of the type
dim id (2) as string
dim Nm (2) as string

in vb6 could be like this

id (1) = tb ("id")
Nm (1) = tb ("Name")
tb.movenext
id (2) = tb ("id")
Nm (2) = tb ("Name")

debug.print id(2)
02
debug.print Nm(2)
John

I would like this to work on b4a




Could you in 5 to 10 program lines show how this really works?
because I arrive as you can see through the images until having the whole base inside a string
[01 Mary 02 John]
but for this I had to make a program to separate the data from there.
and I know it has a super simple form but I do not think

What is SQL1 in your code? A connection to the MS SQL database? A local (to the device) SQLite database?

Do you want to continue using the library your using for MS SQL access or do you want to switch to JdbcSQL? If you are going to switch to JdbcSQL, then any locally accessed SQLite database must also be managed by this library. The connection string for JdbcSQL is a tad different then for B4A's SQL library and there is no more Cursor (it's a ResultSet). W/JdbcSQL, there are two drivers for MS SQL access, a jTDS driver (here http://jtds.sourceforge.net/) and a MS SQL JDBC driver. The jTDS seems to be easier to set up, but may not work with newer MS SQL versions (may). The MS SQL version may not work on Android (at one time it did not due to defaulting to TLS/SSL that was not "compatible" with Android - or something like that). If you use JdbcSQL, if you look here (https://www.b4x.com/android/forum/threads/sql-tutorial.35185/) at @Erel's first post, you should have enough material to figure this out (it shows how to reference the database drivers with #AdditionalJar, how to do a SQL connection and even how to step through a ResultSet and retrieving SQL variables by column name).