Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Updating Database Table Using Module POOL.

rahul_1996
Participant

‎2021 Dec 17 7:40 AM

0 Likes
689

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.

Preview file
18 KB
Preview file
32 KB
Preview file
19 KB
1 REPLY 1
Read only

Sandra_Rossi
Active Contributor

‎2021 Dec 17 8:08 AM

0 Likes
634

Simple logic:

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