How to update multiple rows at backend and refresh the UI?
Update multiple rows at backend and refresh the UI at the same time.
Some times we need to update multiple rows in grid (Form) and the same time need to refresh the user interface also.
In a form grid there is a check box that is for xyzValue = Yes or No. all the selected records should be update when user press a button. In following image we are going to post all selected reords and at the same time we update all selected rows in back end as well as refresh the UI also.
to do this write following code in your click method of post button.
Ax_dataSource _ Ax_dataSource ; // your data source Table
while select forupdate _ Ax_dataSource where _ Ax_dataSource .Status == AllOpenPosted::Open
&& _ Ax_dataSource .checkBox == NoYes::Yes
// write here your required updation after posting
_ Ax_dataSource .Status = AllOpenPosted::Posted;
_ Ax_dataSource .checkBox = NoYes::No;
_ Ax_dataSource .update();
Ax_dataSource _ds .reread();
Ax_dataSource _ds .research();