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 ?You don't need the count at all.
The correct way is:
B4X:Dim rs As ResultSet = SQL.ExecuteQuery(...) Do While rs.NextRow Log(rs.GetString("Col1")) Loop rs.Close