Home / user-105945

Dejuanfran99's questions

Martin Hope
Dejuanfran99
Asked: 2020-11-10 08:27:15 +0800 CST
  • 1

Hi, I have a java program that creates a sqlite database for me. When I finish the program, I want the database to be deleted so that there is no record of it on the computer. I have the following code:

public void borrarSQLite() {

    try {
            con.getS().executeUpdate("DROP DATABASE peval2");
            System.out.println("BD SQLite eliminada correctamente");
    } catch (SQLException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
        System.err.println("ERROR AL ELIMINAR LA BD SQLite");
    }
}

I have tried to execute the query directly in SQLite and it tells me the following:

near "DATABASE": syntax error: drop DATABASE
java
Martin Hope
Dejuanfran99
Asked: 2020-11-08 11:36:27 +0800 CST
  • 1

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