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;
}
Ajouter un commentaire