InstantForum 2017-1 FinalStrataFrame Forumhttp://forum.strataframe.net/StrataFrame ForumTue, 09 Jun 2026 16:02:13 GMT20http://forum.strataframe.net/FindPost2478.aspxIf I create a view and then build a BO based on that view and then bind a grid to that BO, can I delete rows in the grid and have it persist back through the BO to the view and delete the selected rows? I do have more than one table in my view. Dont know if that would matter.<br> <br> ThanksFri, 25 Aug 2006 14:00:01 GMTStarkMikehttp://forum.strataframe.net/FindPost2480.aspxWe have some users that are creating business objects off of views and creating "Instead Of" triggers on the database, but, no, you cannot delete records from a view unless you either index the view or create INSTEAD OF triggers on the view that will allow you to override the DELETE operation on the view.&nbsp; You'll also need to modify the partial class after it is built to declare the field that will be the "primary key" for the view so the business object can execute the delete operations on the server.</P><P>You could also create stored procedures to delete the records from the view and tell the business object to use the specified delete stored procedure, but again, you'll need to modify the partial class to tell the business object which field to call the primary key.Fri, 25 Aug 2006 14:00:01 GMTStrataFrame Team