Commit changes from a editable column in a repeating grid to the database
I am using a repeating grid in the UI whose columns are dropdown and editable.
This grid is sourced from a page list which is copied from a data page.
It also has a column with a button Save after each row to save the changes to the database.
To commit changes to the data base, on the Save button after each row i am using an event on click- run activity which uses an RDB-Save.
I use a property-set to get all the properties from the source page list of the grid to BusinessAdminPortalPage and then perfrom a rdb-save with the below connect sql:
The issue i face here is : When i click on the dropdown in the grid column and change the value, then click on save button, the value that is copied to the BusinessAdminPortalPage is the old value, not the changed one.
I tried post value too . It did not work. I did not see the value of the particular column property posted anywhere in the clipboard.
Does your DB table have a BLOB (pzpvStream column)? If it does, an RDB-Save will not work...that method cannot update the BLOB, only exposed columns. The next time you do an Obj-Open it'll bring back the old value from the BLOB.
Posting the value of the column to the clipboard - As mentioned by Gisela_R, if it isn't populated on the clipboard then it can't be saved to the DB. A "Post Value" on change of the field will ensure this is populated.