Android Question RowCount in JdbcSQL

[mikhatri]

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

 

[Erel]

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:

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.