Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

clarify updateInt method in ResultSet

 
Gary Frick
Greenhorn
Posts: 28
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can someone tell me why I am not seeing the effect of updateInt on the row in resultSet.
Scenario:
1). I do a query to recieve one record in my resultSet.
2). Display record for user to verify.
3). If user changes a field value, I apply the users change to the field value in the resultSet row via an updateInt() method.
4). I pass the resultSet to a class/method that handles the inserts
5). Method inserts updated record into another table in same Database.
Problem:
Since I am inserting the modifed record into another DB, I don't do the updateRow() method. Instead I do a separate Insert using the modified resultSet. However, the ResultSet isn't reflecting the change. I even attempt to display the ResultSet after doing the updateInt but it doesn't show the change either.
rs.updateInt(<value>,<pos> ;
rs.first();
rs.getString(<value> ;
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic