Hi I am wishing to (1) locate the newest record in a database (latest date and time) (2) update the last column (27th) labelled PROFIT_LOSS I have the following code but it seems to update all records in the database Can't see what I am doing wrong? ****************************************************** // Update Profit/Loss field
// retrieve newest record from the table rs = s.executeQuery("SELECT * FROM TABLE ORDER BY Trading_Date DESC," + " Trading_Time DESC FETCH FIRST ROW ONLY"); rs.next(); // and now update the Profit/Loss field............. // parameter 27 is profit (dec) psUpdate = conn.prepareStatement("update TABLE SET PROFIT_LOSS=?"); statements.add(psUpdate); psUpdate.setDouble(1, profit); psUpdate.executeUpdate(); // commit the above transactions conn.commit(); // end updating Profit ************************************************************ Thanks for any advice Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/Updating-the-last-column-in-the-newest-record-tp143710.html Sent from the Apache Derby Users mailing list archive at Nabble.com.