Thank you John
I shall try your suggestion
Functionality is more important than elegance for me :)
Bob M
--
View this message in context:
http://apache-database.10148.n7.nabble.com/Processing-a-subset-of-records-correctly-tp145844p145848.html
Sent from the Apache Derby Users
On 05/04/2016 08:45, Bob M wrote:
I have just realized that I am processing the subset in reverse order (i.e.
latest date backwards)
I want to process in earliest date forwards direction
rs = s.executeQuery("SELECT * FROM xxx WHERE TRADE_NO <>0 ORDER BY
Trading_Date DESC,"
+ "
I have just realized that I am processing the subset in reverse order (i.e.
latest date backwards)
I want to process in earliest date forwards direction
The subset should consist of 102 records
I ignore the most recent
I look at the earliest - and record the prediction only
For the rest I record