Skip to Content

ExecuteFromDB Issue: Buffer vs DB

Hi all,

I would like to get some help/explanation regarding an issue that I'm facing with ExecuteFromDB.

My goal is to build certain logic by comparing the value of certain attribute before and after a change was performed by the user. To achieve my goal, I want to compare the value of the buffer VS the value of DB.

However, when performing the query ExecuteFromDB, I’m getting/reading the same value as the one on the buffer (UI).


Is there any explanation to the issue that I’m facing?


Please find below an screenshot of my coding + debugging session.



Any tip/suggestion/solution is welcome.


Thanks in advance.


Kind regards,


Andres


BTW: I found 2 similar post but none of them offer a solution/explanation to my problem.

http://scn.sap.com/thread/3874938

http://scn.sap.com/thread/3785028

ExecuteFromDB.png (185.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Mar 21, 2016 at 01:41 PM

    Hello Andres,

    As you can see in one my post I had similar issues. From the screenshot of yours, I can see that you are using Execute and ExecuteFromDB function which will return the buffer value and DB value for later one.

    If you want to read from DB, then use ExecuteFromDB function. But using this function, I faced an issue that the "this" node gets overwritten from the DB values. You can try passing the current node values to a variable and after getting value from DB, pass it back to "this" node from variable and do your comparison.

    Regards,

    Mohan Babu

    Add comment
    10|10000 characters needed characters exceeded