6.6 Data Queries and Widgets II - Need Help w/ Error

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? 

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

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

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