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!
posted 12 years ago
use the 'ORDER BY description' in your SQL statement. The ResultSet represents the order of the SQL query.