tagen
Posts: 19
|
| Posted: 09/01/2009, 8:37 PM |
|
I have a editable grid where most columns are made labels only one field is editable. When this editable changes value I want to update the table.
I have used the Features->Ajax->UpdateDB to do it and I get the table updated, but it updates all rows in the table, but I only want the rows with a specific value changed - the key is in the grid as a label value.
In the Table parameter screen I have tried several of the option to limit which rows that should be updated, but it always update all rows in the table.
My question can it be done and if yes how to do that ?
Many thanks in advance
Tage
|
 |
 |
damian
Posts: 838
|
| Posted: 09/02/2009, 3:22 AM |
|
if the other values dont change (they are labels you cant change them) does it matter if they update with the same values?
_________________
if you found this post useful take the time to help someone else.... :)
|
|
|
|
tagen
Posts: 19
|
| Posted: 09/02/2009, 8:38 AM |
|
Yes and No, the other values in the grid doesn't change, but the key-field to be used in the update operation could be in more than one row and I would like the change for one row to update all the rows. btw the key-field I want to use in the update isn't the key field in the table. The field I want to use is kind of an alias for the real key-field.
If updating all the fields in the table is the only way, then I fine with that too, because I know that there will be no more than 6 rows with the same alias, but it would have nice to get all the rows with the same alias updated when one of them changes.
|
|
|
|
tagen
Posts: 19
|
| Posted: 09/03/2009, 8:49 PM |
|
After having testet a lot of combination I think I have found the solution.
The solution is :
Insert a hidden readonly textbox which contains the value that should be used in the where clause of the update
In the Features->operation parameters->Custom Update - update both the field that changes and the hidden textbox field
In the Features->operation parameters->Custom Update - insert a Where with the hidden textbox field - change the parameter type to control
Then the all the rows that contains the hidden textbox value are updated.
Now I just have to find out a way to refresh the browser, so all the rows that have been changed in the grid shows the new value..
|
|
|
|
|
