iOS Question How to judge whether there are records in the sqlite query result?

[watesoft]

In B4I , How to judge whether there are records in the sqlite query result?
In B4A, I can use:

If cur.RowCount>0 Then
     i=k+1  
else
     i=k
end if

 

[Erel]

Don't use Cursor at all.

Only ResultSet:

Dim rs As ResultSet = sql.ExecQuery2(...)
Do While rs.NextRow
 'read records
Loop

 

[watesoft]

Don't use Cursor at all.

Only ResultSet:

Dim rs As ResultSet = sql.ExecQuery2(...)
Do While rs.NextRow
 'read records
Loop

Hi Erel
I know ResultSet,but how to deal with "If Else" statement.

 

[Erel]

What exactly are you trying to do?

If you are only interested in finding out whether there are results or not:

If rs.NextRow Then
 'There are results
Else
 'There are no results
End If

 

[watesoft]

What exactly are you trying to do?

If you are only interested in finding out whether there are results or not:

If rs.NextRow Then
 'There are results
Else
 'There are no results
End If

Yes,thanks Erel.