Hi there
I have the following code:-
******************************************************************************
// retrieve the last record from the table
rs = s.executeQuery("SELECT * FROM USD_JPY ORDER BY Date DESC, Time DESC
FETCH FIRST ROW ONLY");
rs.next();
String Date1 = rs.getString("Date");
String Time1 = rs.getString("Time");
myConsole.getOut().println("Date/Time: " + Date1 + ", " + Time1);
// Update this record by adding predicted return and predicted class
psUpdate = conn.prepareStatement("UPDATE USD_JPY SET
Return_predicted=?,Class_predicted=?");
statements.add(psUpdate);
psUpdate.setDouble(1, return_current);
psUpdate.setString(2, class_current);
conn.commit();
myConsole.getOut().println("Updated latest record with predicted return: " +
return_current + ", predicted class: " + class_current);
***********************************************************
However, the record is NOT being updated as I am wishing it to be ?
Any ideas ?
Bob M
--
View this message in context:
http://apache-database.10148.n7.nabble.com/Problem-updating-a-record-tp135856.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.
