Hi All
I am working on the 11.6.22 version of outsystems. I'm new to outsystems and am trying to create a holiday list for employees. When I try to delete my holiday list I'm getting the following error. Can anyone please guide me how to solve the same.
"The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "OSFRK_OSUSR_VLH_EMPHOLIDAY_OSUSR_VLH_EMPHOLIDAY_HOLIDAYDAY". The conflict occurred in database "SQDV5D047", table "dbo.OSUSR_VLH_EMPHOLIDAY", column 'HOLIDAYDAY'. The statement has been terminated."
Hi,
Well, the constraint means there is another record that prevents you of deleting that record.
Either change the Delete rule, or change the order of deleting the list oif records, so it will succeed
Hi Kavya Balaji,
keep all references for 'Holidayday' either Delete or ignore.
Thank you for your replies J and Poonam Verma. I had set the id of the entity to the entity attribute and that was the cause the above issue.
I was also stuck in this problem. (As Mr J said in previous comment) Then i changed the delete rule from Protected to ignore. Then it deleted the specific id from the list.