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
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
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