db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bob M <rgmatth...@orcon.net.nz>
Subject Re: Inserting and deleting records
Date Sat, 31 Jan 2015 13:59:32 GMT
Thank you Dyre for a brilliant reply..................
I do have a TRADE_ID number
Also, I only ever have ONE open trade at any point in time
I follow your three points completely

Because I already have code which retrieves x records ordered by date and
time I am considering the following code to answer my own question
*************************************************
// retrieve and update date and time of penultimate record
// I retrieve the latest 2 records
rs = s.executeQuery("SELECT * FROM TABLE ORDER BY Date ASC,"
        + " Time ASC OFFSET x ROWS FETCH NEXT 2 ROWS ONLY");
myConsole.getOut().println("Successfully retrieved latest 2 records from
TABLE: ");
rs.next();
String Date3 = rs.getString("Date");
int Time3 = rs.getInt("Time");
s.setCursorName("MYCURSOR");
rs = s.executeQuery("SELECT * from TABLE WHERE Date = '"
        + Date3 + "' AND Time = " + Time3 
+ " FOR UPDATE");
rs.next();
conn.prepareStatement("UPDATE FROM TABLE SET PROFIT_LOSS = profit WHERE
CURRENT OF MYCURSOR").executeUpdate();

myConsole.getOut().println("Updated penultimate record");
*******************************************

Bob M





--
View this message in context: http://apache-database.10148.n7.nabble.com/Inserting-and-deleting-records-tp143723p143729.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.

Mime
View raw message