Home / Questions / 211632
Accepted
Dejuanfran99
Asked: 2020-11-08 11:36:27 +0800 CST 2020-11-08 11:36:27 +0800 CST

Problem with SQLite query (Unexpected Result)

  • 772

Hi, I want to do a delete using SQLite and I would like the query not to be executed if the where field does not exist. Is this possible? Here is an example of my query:

delete from SANCION_DETALLE where SANCION_DETALLE.SANCION = 47

(This query is executed even if there is no sanction 47 in my table)

Thanks in advance.

sqlite

1 Answers

  1. Best Answer

    If you're working in Java, try saving the records you find in an array, and then put in the WHERE condition only the elements of that array. Try this:

    ArrayList<String> registrosEliminados = new ArrayList<>();
StringBuilder query = new StringBuilder();
              query.append("DELETE FROM detalle ");
              query.append("WHERE sancion like '" + sancion + "';");

Statement st = conexion.createStatement();
if(st.executeUpdate(this.query.toString()) == 0) {
     System.out.println("---Sanción no existe o ha sido borrada---");
}else {
     this.registrosEliminados.add(sancion);
}
    • 1