Hello
I am using the following:
I have found the if no rows are returned from the query the resultset appears to be closed on return, so the 'if Not(rs.NextRow) Then' failes with an error, com.microsoft.sqlserver.jdbc.SQLServerException: The result set is closed.
Is this normal ?
Regards
John.
I am using the following:
B4X:
sSQL = "some sql query"
Dim SenderFilter As Object = pConn.ExecQueryAsync("SQL", sSQL, Null)
Wait For (SenderFilter) SQL_QueryComplete (Success As Boolean, rs As ResultSet)
if Not(rs.NextRow) Then
' do something else
else
' do this code
end if
rs.close
I have found the if no rows are returned from the query the resultset appears to be closed on return, so the 'if Not(rs.NextRow) Then' failes with an error, com.microsoft.sqlserver.jdbc.SQLServerException: The result set is closed.
Is this normal ?
Regards
John.