93
Views
2
Comments
Insert Statement Conflict
Question

Hi I'm very new to outsystems and I'm following the online courses. I'm in the mobile development course and I am doing th ToDo App. I've followed the instructions and did what it is but I still get this error

The INSERT statement conflicted with the FOREIGN KEY constraint "OSFRK_OSUSR_KZ0_TODO_OSSYS_USER_USERID". The conflict occurred in database "XP07HX050", table "dbo.ossys_User", column 'ID'.
The statement has been terminated.

I did not leave any inputs blank, can anyone please explain this to me?any help is greatly appreciated. Thank you

Hi Dianara,

Your entity had an attribute of type UserId Identifier. It need to be filled with an I'd of a record from the users entity.

Regards,

Daniel

Dear, 

If your Query Paramter datatype is "User Identifier" then, please do the following:

Screen 1: Showing Parameter datatype

Screen 2: Highlighting the User Identifier

Screen 3: Once click Test SQL, you may get this error as shown below:

Screen 4: If you are getting this error, please add the value of User Identifier in Test Inputs section:


That's it :-)

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