Hello.
If you take a look at the picture, "L" is a variable defined as list in my application.
How can I access the values seen in the picture?
For example the value of rowsInResult which is 1.
Thank you
Normally, yes.
But I notice now that I get an error when asking for L.size:
java.lang.ClassCastException: net.sourceforge.jtds.jdbc.JtdsResultSet cannot be cast to java.util.List
Dim data As List
data.Initialize
Do While L.NextRow
data.Add(Array(L.GetString("col 1"), L.GetInt("col 2"))
loop
Dim SecondRow() As Object = Data.Get(1)
Dim data As List
data.Initialize
Do While L.NextRow
data.Add(Array(L.GetString("col 1"), L.GetInt("col 2"))
loop
Dim SecondRow() As Object = Data.Get(1)
Thank you Erel.
In the 4th line, can the strings be added in the array dynamically based on how many columns there are? In your example, there are two.
In the 6th line, it gets the column names?
Dim data As List
data.Initialize
data.Add(Array(l.GetColumnName(0), l.GetColumnName(1))) 'gives you the column names in the first row
Do While l.NextRow
data.Add(Array(l.GetString("col 1"), l.GetInt("col2")))
Loop
Dim o() As Object=data.Get(0) ' column name
Log(o(0)) 'col 1 name
Log(o(1)) 'col 2 name