topic Updating Database Table Using Module POOL. in Application Development and Automation Discussions

Updating Database Table Using Module POOL.

rahul_1996 — Fri, 17 Dec 2021 07:40:47 GMT

Hi ,

I want to update a database table using module pool.

In screen the value will be given to be updated in database based on vendor number after pressing change button, but problem is blank fields is also being updated i am sharing screenshot of my screen and code.

Please suggest me how to do that.

Re: Updating Database Table Using Module POOL.

Sandra_Rossi — Fri, 17 Dec 2021 08:08:18 GMT

Simple logic:

Retain values of existing record in database table (in variable)
If the screen field is NOT blank then update the corresponding field of variable above
Repeat for each field
Update the whole record in database table