I would like to know what is the proper way to keep track, or better yet make a comparison between the cell or control (editText or ComboBox) that's been changed by the user. So in that manner I can proceed to make the "UPDATE" query for that field alone only the field/fields that have changed.
I thought I could do that by comparing the control contents with the DBDataSource. But unfortunately I found out that the contents on the DBDataSource change as soon as the change has been made to the field (or cell in case of the matrix).
I thought I would use an array to keep the original contents of the matrix cells, but I have not been able to figure out at what point to re-dimension it and fill it in.