B4J Question How to retrieve value from spesific field?

[incendio]

Hi guys,

I have codes like these

Sub Test
   Private RS As ResultSet
   Private Qry as SQL
   RS = Qry.ExecQuery("select * from table where id = 10")
   For i = 0 To RS.ColumnCount - 1
      Log(RS.GetString(RS.GetColumnName(i)))
   Next
End Sub

Raised an error
(SQLException) java.sql.SQLException: The result set is not in a row, use next

How to fix that error?

NB : Can't use do while RS.NextRow caused number of columns are variable.

 

[Erel]

Make sure to close the result set when done.

Can't use do while RS.NextRow caused number of columns are variable.

No relation between the two. You must use RS.NextRow:

Dim rs As ResultSet = QRY.ExecQuery2("select * from table where id = ?", Array(10))
Do While rs.NextRow
  For i = 0 To RS.ColumnCount - 1
      Log(RS.GetString(RS.GetColumnName(i)))
   Next
Loop
rs.Close

 

[incendio]

Thanks, it worked.