Posted By:
juri_vrljicak
Posted On:
Wednesday, November 9, 2005 11:10 AM
i managed to worked it out like this...
public void jdbTable3_mouseClicked(MouseEvent e) {
//source
ReadRow readRow = (ReadRow) queryDataSetArticles.getStorageDataSet();
//destino
DataRow dataRowLineas = new DataRow(queryDataSetLineas);
ReadWriteRow readWriteRow = (ReadWriteRow) dataRowLineas;
//Cabecera
DataRow dataRowCabecera = new DataRow(queryDataSetCabecera);
ReadRow readRowCabecera = (ReadRow) queryDataSetCabecera.
getStorageDataSet();
String uid = readRowCabecera.getString("uid");
// System.out.println(uid);
// System.out.println(readWriteRow.getColumn(1));
queryDataSetArticles.copyTo(new String[] {"id", "sku", "producto",
"color", "size"},
readRow,
new String[] {"article_id", "sku",
"product", "color", "size"},
readWriteRow);
System.out.println(readWriteRow);
readWriteRow.setString("uid", uid);
readWriteRow.setInt("quantity_ordered", 0);
readWriteRow.setInt("quantity_delivered", 0);
System.out.println(readWriteRow);
DataRow dataRow = (DataRow) readWriteRow;
queryDataSetLineas.addRow(dataRow);
queryDataSetLineas.saveChanges();
queryDataSetLineas.refresh();
}