inline edit of view with multiple base tables

This topic is locked

inline edit of view with multiple base tables	4/12/2016 3:34:47 PM
PHPRunner General questions
P Petey author I have a view which I created in my database that is composed of several separate tables. I added this view to my phprunner 8.1 project in a list page to display to data to the user. I would like to allow the user to edit the data using the inline edit functionality. But when i try to do an inline edit I get the error "view name is not updatable because the modification affects multiple base tables" I can edit the view in SQL server management studio so I am wondering if this is a phprunner limitation? or is there something I can do to get this to work. Thanks


	Sergey Kornilov admin 4/13/2016
	This is SQL Server limitation, it will only work if you update fields from one of tables: http://stackoverflow.com/questions/7281054/sql-updatable-view-with-joined-tables When you doing that in SQL Server Management Studio it knows which table to update. PHPRunner doesn't have access to this info and it trying to update the view itself. It should work for you if you only make fields from single table editable. Remove fields from joined tables on Add/Edit pages.