Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Getting next record  RSS feed

 
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.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!