Jack Cole Well-Known Member Licensed User Longtime User Nov 15, 2014 #1 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?
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 Expert Licensed User Longtime User Nov 15, 2014 #2 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
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 Well-Known Member Licensed User Longtime User Nov 15, 2014 #3 Thanks stevel05. That works for me!
JakeBullet70 Well-Known Member Licensed User Longtime User Mar 2, 2015 #4 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?
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 B4X founder Staff member Licensed User Longtime User Mar 2, 2015 #5 There is no server here. The iSQL library works with local SQLite databases.
JakeBullet70 Well-Known Member Licensed User Longtime User Mar 2, 2015 #6 Erel said: There is no server here. The iSQL library works with local SQLite databases. Click to expand... Wrong b4x... The question should of been for b4j with MySQL. Last edited: Mar 2, 2015
Erel said: There is no server here. The iSQL library works with local SQLite databases. Click to expand... Wrong b4x... The question should of been for b4j with MySQL.