• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Retriving data from table

 
Ian Cockcroft
Greenhorn
Posts: 29
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all, the following code gets data from an ACCESS database.
I need to put the data in textFields and a checkBox, why is so difficult?
OrderDate is a DATE field.
OrderFilled is a Yes/No filled.
How should I be doing it?
Regards
Ian


I get the following error aswell, when i comment out the setText() code:
Connection error : java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid cursor state
this really is confusing, i have no idea,
any can help?
 
mustang india
Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
u have to place the cursor at the begining of the result set. All u have to do is put ur data retrivel code inside
//supposing that there is only one row fetched.
if(rs.next()) {
}
rs.next() puts the cursor pointing to the first row fetched by the resultset, if it has fetched something. If there are no rows selected, it returns false.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic