Android Question Get multiple JdbcResultSet in a single ExecQuery2

netsistemas

Active Member
Licensed User
Longtime User
can i do something sql="select * from table1 ; Select * from table2"
in only one ExecQuery?

(like vb60, vb.net, php and other)




Multi - Recordset/ResultSet

B4X: 
Dim Cursor As JdbcResultSet
Cursor = SQL1.ExecQuery("SELECT col1, col2 FROM table1")
Do While Cursor.NextRow
    Log(Cursor.GetString("col1"))
    Log(Cursor.GetInt("col2"))
Loop
 
Sort by date Sort by votes

DonManfred

Expert
Licensed User
Longtime User
Inform about INNER JOIN, LEFT JOIN.
See SQL-Tutorials.

In short the answer is NO. You can not use two queries in one call.

But you can use JOIN to get Values from different tables in one call.

Asuming you are using MySQL

W3Schools.com

W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.
www.w3schools.com

SQLite

A Visual Explanation of SQLite Joins

In this tutorial, you will learn about various kinds of SQLite joins to query data from two or more tables.
www.sqlitetutorial.net

Once you understand how they are working a new world of possibilities appears
 
Upvote 0

DonManfred

Expert
Licensed User
Longtime User
netsistemas said:
Multi - Recordset/ResultSet
Click to expand...
i havn´t seen a B4X implementation of this.
Even not a JDBC-Version of them.

But as written in my 1st answer you can use JOINs to get Values from another table too if they are related to eachother and you can reference them.
 
Upvote 0

aeric

Expert
Licensed User
Longtime User
DonManfred said:
INNER JOIN, LEFT JOIN.
Click to expand...
and UNION.

Example:
B4X: 
Cursor = SQL1.ExecQuery("SELECT 'table1' AS tbl, col1, col2 FROM table1 UNION SELECT 'table2' AS tbl, col1, col2 FROM table2")
Do While Cursor.NextRow
    Log(Cursor.GetString("tbl"))
    Log(Cursor.GetString("col1"))
    Log(Cursor.GetInt("col2"))
Loop
 
Upvote 0

netsistemas

Active Member
Licensed User
Longtime User
I already assumed not, but the truth is that it is something that I have discovered that can be done recently (and look, I have been doing this for years) in other languages, even vb60 with recordset!! And just in case, I asked.
Thanks for the response.
 
Upvote 0
You must log in or register to reply here.

Similar Threads

W
  • Question
Android Question Problem executing ExecQuery2.
Replies
3
Views
663
warayTek
W
  • Solved
Android Question UPDATE SQL not working using ExecQuery2
Replies
3
Views
962
mohdosala
  • Solved
Android Question Smartstring with ExecQuery (which is actually an ExecQuery2)
Replies
2
Views
1K
JonnyCav
  • Question
Android Question SQL - no rows in resultset with ExecQuery2
Replies
17
Views
4K
Mahares
M
C
  • Question
Android Question MSSQL-JDBC Minimalistic Example
2
Replies
27
Views
24K
MrKim
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…