Updating a Row
1 posts in topic
Flat View  Flat View

Posted By:   Ahu_Eryuruk
Posted On:   Wednesday, July 18, 2001 06:29 AM


I want to update a row which I selected with a select statement but; I don't want to write
an update statement again. Instead, I want to change the value of the column of the row
directly. Is there any way to do that. any help is appreciated.



Re: Updating a Row

Posted By:   Jeff_Halleux  
Posted On:   Thursday, July 19, 2001 12:43 AM

Steps to follow :

1. Create a statement that is updatable - using the option ResultSet.CONCUR_UPDATABLE

2. Move to the desired row

3. Use one of the method updateXXX on the resultset.

4. Call updateRow() on the resultset.

That's it, JFH.

About | Sitemap | Contact