4
I’m running it through the database, and I have a problem SQL
return an empty value. It is actually possible for this to happen and therefore I need to keep ready for it. Which method to identify that no record with that parameter was found ?
I’ve tried using the TRY/CATCH
but it didn’t work.
My code is like this:
ResultSet rs_tbl_PESSOAS = con.query("SELECT * FROM tbl_PESSOAS WHERE XXXX= '" + w_obj.getString("XXXX") + "' and COD_IDENT_PESSO = '" + w_obj.getString("COD_IDENT_PESSO") + "';");
ResultSetMetaData rsmd = rs_tbl_PESSOAS.getMetaData();
int columnsNumber = rsmd.getColumnCount();
What Voce wants is to check if the query did not return results to the correct result set?
– user28595
I want to get to if there are data returned in this query. If the database returned some line in SQL
– Renan Rodrigues