Android Question Question about getting values from a variable

[padvou]

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

 

[KMatle]

You mean L.Size ?

 

[padvou]

You mean L.Size ?

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

 

[padvou]

I changed the L as List to L as JdbcResultSet but the question remains as to how I can read the values from the names as shown in the initial picture.

 

[DonManfred]

WHAT is L in your initial post?

What comes out if you do a LOG(L)?

 

[padvou]

WHAT is L in your initial post?

What comes out if you do a LOG(L)?

It's a JdbcResultSet

 

[DonManfred]

It's a JdbcResultSet

Do While L.NextRow
  log(g.GetString("fieldname")) ' Or GetInt/GetLong.....
loop

B4A - SQL

 

[padvou]

Do While L.NextRow
  log(g.GetString("fieldname")) ' Or GetInt/GetLong.....
loop

B4A - SQL

What is g in g.GetString.... ?

 

[Mahares]

What is g in g.GetString.... ?

It has to be:

dim g as  JdbcResultSet

although I do not use it often .

 

[padvou]

It has to be:

dim g as  JdbcResultSet

although I do not use it often .

Do While L.NextRow
  log(g.GetString("fieldname")) ' Or GetInt/GetLong.....
loop

B4A - SQL

Do While L.NextRow
  log(g.GetString("fieldname")) ' Or GetInt/GetLong.....
loop

It seems that this moves only forward. So if I need to do something more and start it from the beginning?

 

[Erel]

You cannot go back. Collect the data you need and add it to a List.

 

[padvou]

You cannot go back. Collect the data you need and add it to a List.

How is this done?
For example if the recordset contains one row of 3 column names and 5 rows of data?

 

[Erel]

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)

 

[padvou]

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?

 

[Mahares]

t 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

 

[padvou]

To go back to my initial question:
L is a net.sourceforge.jtds.jdbc.JtdsResultSet
It has some values as shown in the picture.

How can I read "rowsInResult" using probably javaobject?

Dim b4xResultSet As JavaObject = L
Dim jResultSet As JavaObject = b4xResultSet.?????????

 

[Erel]

This is a private field. You can get it with jReflection, however this is the wrong solution as it is likely to break in all kinds of cases.

 

[padvou]

This is a private field. You can get it with jReflection, however this is the wrong solution as it is likely to break in all kinds of cases.

Just for the sake of it, how would it be done?

 

[Erel]

Dim r As Reflector
r.Target = Result
r.Target = r.GetField("L")
log(r.GetField("rowsInResult"))