Change all data for a related ID in the table
Good Morning

Dear I am trying to assign an action

when I change in table X the table Y that has several IDs of table X also change.

How can I perform this action in SQL or something that I can solve in the best way.


Thank you so much
mvp_badge
MVP
Solution

Right, you can change the Laudos in your action ProgramacaoCreateOrUpdate2, example:

Create one Input Variable ProgramacaoId_Old:

then, after createOrUpdateProgramacao, build this advanced query:


Hope It's help.

Regards.

mvp_badge
MVP

Hi Jone,

There are several ways to do this type of functionality, but in order for us to indicate the best path for you, can you give more details about what you need? (can attach images and further explanations please).

Per hour, follows a post that has some tips:

https://www.outsystems.com/forums/discussion/53963/how-to-execute-sql-update-statement/

Regards.

follow details

mvp_badge
MVP
Solution

Right, you can change the Laudos in your action ProgramacaoCreateOrUpdate2, example:

Create one Input Variable ProgramacaoId_Old:

then, after createOrUpdateProgramacao, build this advanced query:


Hope It's help.

Regards.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.