Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Getting next record

 
Gladys Galeos
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am trying to navigate thru large number of records. I am having problem
with the move-to-next record process. I have a recordid field (unique) but our client requires that records be sorted by their description. Example,
I am currently in recordid 5, when i click on the next button, the next record that will appear may or may not be recordid 6. How will I implement an accurate navigation if my reference id will not be the record id? Any suggestions? Please help!
 
Anonymous
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
use the 'ORDER BY description' in your SQL statement. The ResultSet represents the order of the SQL query.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic