Hey all,
I am getting this error when i am trying to add a record in a view
any idea what this means?
Solved
Update or insert of view or function 'vw_item_container' failed because it contains a derived or constant field.
- Vanguard
- 22 replies
Best answer by Renée Evertzen
Hey Timothy,
Views compile their data with potentially more than one table as their source of information. That means that when you're trying to add a record to a view, the application does not know where to leave this information exactly.
If you want to insert data into a view or update the data in a view, you will have to add an instead of trigger to this view that contains the specified insert statements. More information on instead of triggers can be found here:
- https://docs.thinkwisesoftware.com/docs/sf/business_logic#trigger-/-event
- https://www.sqlservertutorial.net/sql-server-triggers/sql-server-instead-of-trigger/
Hope this helps!
This topic has been closed for replies.
+4Hey Timothy,
Views compile their data with potentially more than one table as their source of information. That means that when you're trying to add a record to a view, the application does not know where to leave this information exactly.
If you want to insert data into a view or update the data in a view, you will have to add an instead of trigger to this view that contains the specified insert statements. More information on instead of triggers can be found here:
- https://docs.thinkwisesoftware.com/docs/sf/business_logic#trigger-/-event
- https://www.sqlservertutorial.net/sql-server-triggers/sql-server-instead-of-trigger/
Hope this helps!
- Vanguard
- 22 replies
Yes i fixed the problem yesterday but forgot to update the question. Thanks anyways!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.