iOS Question how to get ResultSet data in special row

[cambol]

rs As ResultSet = SQL2.ExecQuery(strSQL) , how to get ResultSet data in special row

they can be use rs.position in b4a , but not in b4i

 

[Erel]

What do you mean with special row? Do you want to get the rowid?

 

[tufanv]

What do you mean with special row? Do you want to get the rowid?

I think means the cursor.position equivelent in b4i. For example result set consists 30 rows. he want to get the row 17

 

[cambol]

yes , like cursor.position in b4A

 

[tufanv]

yes , like cursor.position in b4A

I am not sure but this may work :

dim rownumber as int = 0
Do While resultset1.NextRow
if rownumber = 14 then
something = resultset1.getint("buyprice")
end if
rownumber=rownumber+1
Loop

 

[Tamer El-Shimy]

I am not sure but this may work :

dim rownumber as int = 0
Do While resultset1.NextRow
if rownumber = 14 then
something = resultset1.getint("buyprice")
end if
rownumber=rownumber+1
Loop

Really I understand this is about JDBCResultSet not ResultSet the normal has Position and RowCount properties.

 

[Tamer El-Shimy]

JDBCResultSet is normal to create your own integer row number either starting from 0 or 1 then check , Keep in mind that in your case 14 is the 15th Row not the 14th.