Android Question RowCount in JdbcSQL

mikhatri

Member
Hello, I am new to using MySQL in B4A. I tried a library called "JdbcSQL". It works very well, but there is no option to get the total row count like ResultSet.RowCount in SQL. Also, there is no function to go to the previous row like Cursor1.PreviousRow.

Please help me if you have any ideas for that.

-Thanks
 
Sort by date Sort by votes

Erel

B4X founder
Staff member
Licensed User
Longtime User
Moved to the questions forum.

The number of rows isn't known as the data might not be fetched at once.
You can go the previous row with:
B4X: 
ResultSet.As(JavaObject).RunMethod("previous", Null)
It returns false if the position is now before the first row.

And it might not work in all cases. It depends on the connection settings.
 
Upvote 0
You must log in or register to reply here.

Similar Threads

A
  • Question
Android Question Unknown problem while using ExecNonQueryBatch, JdbcSQL [Solved]
Replies
8
Views
2K
Anser
A
W
  • Question
Android Question JdbcSQL with BLOB field
Replies
8
Views
3K
Wendell Carneiro Mendes
W
  • Question
Android Question RowCount takes ages
Replies
12
Views
3K
Erel
M
  • Question
Android Question jdbcSQL connection to mysql debug mode works correctly but release mode doesn't work
Replies
2
Views
4K
mostosoft
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…