Hi
So far, I have only needed to update a single field in the latest derby
record with code as follows:-
// retrieve the latest trade record
rs = s.executeQuery("SELECT * FROM xxxx ORDER BY TRADE_NO DESC NULLS LAST
FETCH NEXT 1 ROW ONLY");
rs.next();
String Date3 = rs.getString("Trading_Date");
int Time3 = rs.getInt("Trading_Time");
// and now update the latest trade record
s.setCursorName("MYCURSOR");
rs = s.executeQuery("SELECT PROFIT_LOSS FROM xxxx WHERE Trading_Date = '"
+ Date3 + "' AND Trading_Time = " + Time3
+ " FOR UPDATE");
rs.next();
psUpdate = conn.prepareStatement("UPDATE xxxx SET PROFIT_LOSS = ? WHERE
CURRENT OF MYCURSOR");
statements.add(psUpdate);
psUpdate.setDouble(1, profit);
psUpdate.executeUpdate();
} // end of updating the latest trade record
Now, I wish to update seven consecutive fields in the latest derby record
What is the best way to recode the above section of code?
Many thanks
Bob M
--
View this message in context:
http://apache-database.10148.n7.nabble.com/Updating-several-consecutive-fields-in-a-record-tp146385.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.
