Skip to Content
0
Former Member
Dec 18, 2006 at 04:36 PM

HowTo: Keep track of changes on Form and/or Matrix?

17 Views

Hi everyone.

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.