Thanks Rick
Keeping the code 'in sync' is difficult when applying example code :)
Will the following do what I am seeking?
rs = s.executeQuery("SELECT from tablename ORDER BY Date ASC, Time, ASC
> FETCH FIRST ROW ONLY");
> rs.next();
> String Date = rs.getString("Date");
> String Date = rs.getString("Time");
> myConsole.getOut().println("Date/Time " + Date ", " + Time);
>
>
At this stage , I am successfully printing out the correct record data!
Now I wish to delete this record..........
conn.setAutoCommit( false );
s.setCursorName( "MYCURSOR" );
rs = s.executeQuery( repeat the above...............);
rs.next();
psDelete = conn.prepareStatement( "DELETE from tablename where
current of
MYCURSOR" );
statements.add(psDelete);
}
}
p.s.
code further above this lot................
ArrayList statements = new ArrayList();
PreparedStatement psInsert = null;
PreparedStatement psUpdate = null;
PreparedStatement psDelete = null;
Statement s = null;
ResultSet rs = null;
--
View this message in context:
http://apache-database.10148.n7.nabble.com/Retrieving-the-oldest-record-and-deleting-it-tp134915p134956.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.
