Good to the whole community. I have a problem, I'm doing a program with Netbeans
and I use the JDateChooser
but when I make a query and delete it does not delete the record but it gives me an error.
Code:
tblinsumos.getSelectionModel().addListSelectionListener(new ListSelectionListener() {
@Override
public void valueChanged(ListSelectionEvent lse) {
if (tblinsumos.getSelectedRow()!=-1) {
int fila=tblinsumos.getSelectedRow();
txtgenerico.setText(tblinsumos.getValueAt(fila, 1).toString());
txtcomercial.setText(tblinsumos.getValueAt(fila, 2).toString());
cbforma.setSelectedItem(tblinsumos.getValueAt(fila, 3).toString());
txtconcent.setText(tblinsumos.getValueAt(fila, 4).toString());
txtstock.setText(tblinsumos.getValueAt(fila, 5).toString());
jfecha.setDate((Date) tblinsumos.getValueAt(fila, 7));
txtlote.setText(tblinsumos.getValueAt(fila, 8).toString());
}
throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
}
});
}
The error it throws:
ERRORUnknown column ´deres´in ´Where clause´
In the table I have it this way:
1 idinsumos
2 genérico
3 comercial
4 formafarma
5 concentración
6 stock
7 existencia
8 fecha
9 lote
I am not charged with the date, nor the lot number. Please, and I'm sorry, I'm new to this programming, a million thanks.