Hi,
I was thinking and googling and I have found the solution.
This is the code,
public String borrar_action() {
// TODO: Process the action. Return value is a navigation
// case name where null will return to the same page.
form1.discardSubmittedValues("salvar");
try {
int categoriaId = ((Integer)categoriaDD.getSelected());
RowKey rk = tableRowGroup1.getRowKey();
int subcategoriaId = (Integer)subcategoriaDataProvider.getValue("SUBCATEGORIA.ID_SUBCATEGORIA", rk);
String[] fieldIds = {"CATEGORIA_SUBCATEGORIA.ID_SUBCATEGORIA", "CATEGORIA_SUBCATEGORIA.ID_CATEGORIA"};
Object[] values = {new Integer(subcategoriaId), new Integer(categoriaId)};
rk = categoria_subcategoriaDataProvider.findFirst(fieldIds, values);
if (rk != null){
categoria_subcategoriaDataProvider.removeRow(rk);
categoria_subcategoriaDataProvider.commitChanges();
categoria_subcategoriaDataProvider.refresh();
}
rk = tableRowGroup1.getRowKey();
if (rk != null) {
subcategoriaDataProvider.removeRow(rk);
subcategoriaDataProvider.commitChanges();
subcategoriaDataProvider.refresh();
}
} catch (Exception ex) {
log("ErrorDescription", ex);
error("Error: " + ex.getMessage());
}
return null;
}
What I do is to get the Id (PK) from the DropDownList that take me to the Table. Into the table I click the button in the row a want to delete. That is the reason,
RowKey rk = tableRowGroup1.getRowKey();
int subcategoriaId = (Integer)subcategoriaDataProvider.getValue("SUBCATEGORIA.ID_SUBCATEGORIA", rk);
gives me the the Id (PK) I was looking for.
Later I look for the row in the relation table CATEGORIA_SUBCATEGORIA,
String[] fieldIds = {"CATEGORIA_SUBCATEGORIA.ID_SUBCATEGORIA", "CATEGORIA_SUBCATEGORIA.ID_CATEGORIA"};
Object[] values = {new Integer(subcategoriaId), new Integer(categoriaId)};
rk = categoria_subcategoriaDataProvider.findFirst(fieldIds, values);
Once I have the RowKey, I remove first the row in the relation table and secondly I remove the row from the principal table.
Hoping it helps,
Best Regards,
Jose Alvarez de Lara
[Message sent by forum member 'josealvarezdelara' (josealvarezdelara)]
http://forums.java.net/jive/thread.jspa?messageID=344726