fmbma
Posts: 58
|
| Posted: 09/10/2007, 11:16 AM |
|
Is there a way to identify which rows have changed? I want to stamp the row with the login ID. I'm using a custom update, but it updates all the rows in the grid, not just those that change.
|
 |
 |
rho
Posts: 85
|
| Posted: 09/10/2007, 12:34 PM |
|
Simple way: add a hidden field to your row, f.e. OldValue and in the BeforeShowRow event set it to the initial/current value of the value that will be (or will be not) updated, f.e. OldValue = CurrentValue. Then change your SQL so that only those fields will be updated where CurrentValue<>OldValue
|
|
|
|
fmbma
Posts: 58
|
| Posted: 09/10/2007, 12:41 PM |
|
But with this method, if there are a dozen fields in the row, i would have to create hidden fields for each of them, right?
|
|
|
|
Benjamin Krajmalnik
|
| Posted: 09/10/2007, 2:06 PM |
|
Add one hidden field containgn am MD% hash of all of the fields concatenated
together.
Before saving, recalc the hash and compare it to the old one.
"fmbma" <fmbma@forum.codecharge> wrote in message
news:646e59dcdc5c11@news.codecharge.com...
> But with this method, if there are a dozen fields in the row, i would have
> to
> create hidden fields for each of them, right?
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.yessoftware.com/
>
|
|
|
|
|
