To do so, simply double click the data you want to update, then the corresponding data cell will become editable, as seen on the screen above, so you can modify the data in the cell, and then click the Update button to write the modification into the database table.

For example, we want to change the name for the item_id 4 from 'Red Apples" to "Red Delicious Apples" (compare to the screen on the last screen). We click the NAME column of the row corresponding to the item_id 4, the cell becomes editable, and we then change the data in the cell from test to Curtis Lee, then click Update button, the change is written into the ITEM_LIST table in the database.

Note: Not all the result sets can be updated in this way, it depends on the JDBC driver's implementation, and the query statement, as well as your browser. This feature is only available for Internet Explorer of version 5.x and later.

Back to Table Column Definitions.