Log in to AnswerLog in to Follow
UserImage.jpg
Karisma Jutla
3Views
2Comments
Solved
6.6 Data Queries and Widgets II - Need Help w/ Error
Question
Beginner
OutSystems Widgets
Tutorial

Hi, I'm on page 14 of 6.6 Data Queries and Widgets II and am trying to trouble shoot this error. Any ideas as to how this error happened and how to solve it? 

0
0
20 Apr
2021-04-17 09-53-48
José Gonçalves
Champion
Solution

Hi Karisma,

you are trying to delete a record from Movie table that is referenced as foreign key in PersonMovieRole table.

That happens because the delete rule of that foreign key attribute is set to Protect. You would need to change the delete rule to Delete or Ignore to be able to delete that movie with the existing record in PersonMovieRole table.

Check this documentation page to understand how it works:

https://success.outsystems.com/Documentation/11/Developing_an_Application/Use_Data/Data_Modeling/Entity_Relationships/Delete_Rules

Regards

0
0
20 Apr

Thank you! I went back and changed my variables to "Ignore" and it fixed the problem! 

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