iOS Question Counting Rows with resultset

tufanv · Jun 11, 2015

Hello,

I know we must use nextrow method with b4i but i cant count the number of rows with it . Is there an easy vay to count rws of a result set ?

TY

Erel · Jun 11, 2015

You can always add a count(*) column to the query.

"Select Col1, Col2, Count(*) As MyCount FROM ..."

tufanv · Jun 11, 2015

I am using
for i = 0 to cursor4.rowcount-1 and i cant figure out how to use count in query with this purpose . Can you show a little example for my for next ( or can i use do while resultset.nextrow loop instead of for i=0 to rowcount-1 ? )

Erel · Jun 11, 2015

You don't need the count at all.
The correct way is:

Code:

Dim rs As ResultSet = SQL.ExecuteQuery(...)
Do While rs.NextRow
 Log(rs.GetString("Col1"))
Loop
rs.Close

billyrudi · Jun 11, 2015

There is the way to make a previous row metod?

Erel · Jun 11, 2015

No. However you can use DBUtils.ExecuteMemoryTable and then have access to all the items.

billyrudi · Jun 11, 2015

Great. Tanks another time.

tufanv · Jun 11, 2015

Erel said: ↑
You don't need the count at all.
The correct way is:
Code:
Dim rs As ResultSet = SQL.ExecuteQuery(...)
Do While rs.NextRow
Log(rs.GetString("Col1"))
Loop
rs.Close
Click to expand...
Erel Do I have to close the resultset everytime. For example if i use rs1 for 2 different queries do i have to close and use again unlike the cursor ?

Erel · Jun 11, 2015

You always need to close the ResultSet when you are done with it. The same is true with Android cursors.

The variable that holds the ResultSet is not important. If you are using the same variable then you need to close it before you assign it again.

Log in or Sign up

iOS Question Counting Rows with resultset

Similar threads

tufanv Expert Licensed User

Erel Administrator Staff Member Licensed User

tufanv Expert Licensed User

Erel Administrator Staff Member Licensed User

billyrudi Active Member Licensed User

Erel Administrator Staff Member Licensed User

billyrudi Active Member Licensed User

tufanv Expert Licensed User

Erel Administrator Staff Member Licensed User