DELETE

    public boolean deleteTable(){
       
        Environment env = Environment.getStandardEnvironment(processData);
        Database db = SystemWorkspace.getConnectionsWorkspace().getDatabase("MOVEX", env);
        Table table = RepositoryUtil.getTable("Repository", "Table");
        DeleteStatement delTable = new DeleteStatement(table, env.getSessionValues(), env.getDataTypeHandler(), db);
        delTable.addWhere("CHAMP1", "VALEUR1");
        delTable.addWhere("CHAMP2", "VALEUR2");
        delTable.addWhere("CHAMP3", "VALEUR3");
        delTable.addWhere("CHAMP4", "VALEUR4");
        delTable.addWhere("CHAMP5", "VALEUR5");
        try {
            delTable.executeAndClose();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return true;
    }

Etiquettes: