Need ColumnState function

Ron Howerton · August 18th, 2009, 11:25 AM

datatable.rows(n).RowState can be checked to see whether a row in an internal datatable has changed. Is there some way to tell whether a specific column's value for said row has changed without tracking changes as they are made? I was hoping for something like:

table.rows(n)(column).ColumnState

That does not exist, but is there some way to compare the old value for the column against the new column to determine what has changed?

Ron Howerton · August 18th, 2009, 04:29 PM

Hmmmm...25 reads and no suggestions whatsoever. Guess it can't be done!

For those who want to know, I resolved this by retrieving a copy of the record to be updated prior to updating, and comparing column to column to identify changes. I'm surprised there isn't an easier way...

pons_saravanan · August 21st, 2009, 01:01 AM

Quote:

Originally Posted by Ron Howerton

Hmmmm...25 reads and no suggestions whatsoever. Guess it can't be done!

For those who want to know, I resolved this by retrieving a copy of the record to be updated prior to updating, and comparing column to column to identify changes. I'm surprised there isn't an easier way...

what you can do is

Code:

 
for each MyRow as DataRow in TestTable.Rows
if(MyRow.RowState=Modified)'do your part here to check
response.write(MyRow("TestColumn",OrinalVersion) = MyRow("TestColumn"))
end if
end if
next

the above code is written for understanding only. will not be compiled.

Ron Howerton · August 21st, 2009, 08:45 AM

Thank you very much, pons_saravanan!!!

That's exactly what I needed and it has to be more efficient than another DB call and then comparing two rows! I'd obviously ignored the intellisense previously or I'd have known the column index took two parms.

Thanks again!