Skip to main content
October 15, 2022
Question

Add data in a text fields in an interface to update many rows of my db at one go

  • October 15, 2022
  • 5 replies
  • 0 views

Hi

I want add or complete data in a text fields in an interface (image below) to update many rows of my db at one go, instead of updating one by one or row by row

For example, complete the form interface (image above) to update 5 rows at one go... this rows of my db

which would be the best practice or help me with examples?


please help

5 replies

October 16, 2022

Hi,

You can create a process model (generic process so that we can use the same anywhere we want) that contain a UIT and a Write to details process model (see below pic).

And what you only have to do, you have to pass the selected grid data (as we know we can hold the selected data in a local) on clicking the button from your above interface to the generic process model UIT and then you can update that data in the editable grid.

Then after updating the data on clicking submit your updated data will go to write in the db.

Thank You.

October 16, 2022

I hope the above solution will help you to update your data.

danna3499Author
October 20, 2022

Hi Ravis420

As you said i will create 2 interfaces

1. the first for the selectable read only grid and save the selected rows in a local variable...

how i save that selected rows in a local variable?

2. the second for the editable grid for selected rows

how i call the selected rows in this interface?