2) Currently clicking on the Edit icon causes a
new page to open and changes
must be made and saved there. We can associate the double click event of
JQuery (.dblclick) with each of the fields inside a row so that when one
would double click on a field in the row, all fields in the row turn into
text boxes where changes can be made and once the focus is removed, the text
boxes can become text fields again. Once a user decides to commit all
changes, he would click the 'Submit Changes' button and he would receive the
status update regarding the changes in the table.
I'm not sure about your suggestion as the double-click is not a popular
action on a web page. Also, when browsing, one does not have much room
(take for example a text field or an ENUM or a foreign key with a
drop-down for the choices).
How about a new window that would open when clicking the Edit icon? It
would be similar to the distinct page we currently get.