Problem retrieving the 'oldest' record

2013-12-02 Thread Bob M
etc etc. Any ideas on where my code is incorrect ? Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/Problem-retrieving-the-oldest-record-tp135855.html Sent from the Apache Derby Users mailing list archive at Nabble.com.

Re: Problem retrieving the 'oldest' record

2013-12-02 Thread Bob M
in a primary key! Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/Problem-retrieving-the-oldest-record-tp135855p135863.html Sent from the Apache Derby Users mailing list archive at Nabble.com.

Re: Problem retrieving the 'oldest' record

2013-12-02 Thread Bryan Pendleton
It would appear that my so-called 'date' field is not a good field to have in a primary key! You can have just about any datatype in your primary key. The only hard requirement is that the primary key must be unique. Using existing fields from your record which uniquely identify your data is

Re: Problem retrieving the 'oldest' record

2013-12-02 Thread Bob M
my original question... Why does my code not pick up the true 'oldest' record Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/Problem-retrieving-the-oldest-record-tp135855p135869.html Sent from the Apache Derby Users mailing list archive