Bug? Rowcount missing in iSql Resultset

[Jack Cole]

In B4A, you can loop through the results of a cursor by getting the row count from cursor.rowcount. This is missing in B4I. Was this intentional?

 

[stevel05]

It is a different methodology, you need to use the ResultSet's nextrow method to get the next row and check if it returns true or false. As I have literally just found out

 

[Jack Cole]

Thanks stevel05. That works for me!

 

[JakeBullet70]

So are we assuming that the connection is still open and each row (or a batch of rows) is being retrieved from the server as needed?

 

[Erel]

There is no server here. The iSQL library works with local SQLite databases.

 

[JakeBullet70]

There is no server here. The iSQL library works with local SQLite databases.

Wrong b4x... The question should of been for b4j with MySQL.