Android Question MSSQL - Jdbcresult empty but no filter on query

Flav78

Member
Licensed User
good morning

I was trying to read some data from a table on remote MSSQL server, connection is ok but i have a strange problem with this code

CODE:
Dim SenderFilter As Object = sql1.ExecQueryAsync("sql", "SELECT * FROM MYTABLE",Null)

        Wait For (SenderFilter) sql_QueryComplete (Success2 As Boolean, RS As JdbcResultSet)


        If Success2 = True Then

            Do While RS.NextRow
                              ListView1.AddSingleLine(RS.GetString(0))
            Loop
            rs.Close
        Else
            Log(LastException)

        End If

when i run the code the connection is ok: i have checked rs properties and i can see the resultset contains the column names i have in database but it seems haven't read any records from db.

rs.nextrow is false and no data loaded in listview .

I have checked and i have ten records in the table i'm reading and i can't understand what is wrong in what i'm doing.

Can you please help me?

Thank you
 

Flav78

Member
Licensed User
Done,

now i'm entering in the do/loop cycle one time but nothing added in the listview: i'm expecting the cycle is run as much times as records.
 
Upvote 0
Top