topic Re: Editing Query Layer in Data Management Questions https://community.esri.com/t5/data-management-questions/editing-query-layer/m-p/1213559#M44236 <P>Curious if there are any updates to this.</P> Fri, 16 Sep 2022 19:43:51 GMT sofoo 2022-09-16T19:43:51Z Editing Query Layer https://community.esri.com/t5/data-management-questions/editing-query-layer/m-p/648417#M36700 <HTML><HEAD></HEAD><BODY><SPAN>I'm curious if a query layer can be edited. I have created a query layer which joins a table to a FC (table is registered with gdb). The connection used has edit rights to both tables. When I attempt to edit this layer in ArcMap it does not work. I can start the edit session but can't do anything like delete a feature, add a feature or edit attributes.</SPAN><BR /><BR /><SPAN>Thanks</SPAN><BR /><SPAN>Noah</SPAN></BODY></HTML> Mon, 05 Nov 2012 14:00:24 GMT https://community.esri.com/t5/data-management-questions/editing-query-layer/m-p/648417#M36700 NoahHuntington 2012-11-05T14:00:24Z Re: Editing Query Layer https://community.esri.com/t5/data-management-questions/editing-query-layer/m-p/648418#M36701 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">I'm curious if a query layer can be edited. I have created a query layer which joins a table to a FC (table is registered with gdb). The connection used has edit rights to both tables. When I attempt to edit this layer in ArcMap it does not work. I can start the edit session but can't do anything like delete a feature, add a feature or edit attributes.<BR /><BR />Thanks<BR />Noah</BLOCKQUOTE><BR /><SPAN> </SPAN><BR /><SPAN>A Query layer is read-only.&nbsp; It only exists in memory and not as a feature class with edit rights.&nbsp; To edit it you would have to export it to a feature class.&nbsp; However, the exported join would not be connected to the source feature class or table, so your edits of the exported join would not transfer back to the sources.</SPAN><BR /><BR /><SPAN>Using a relate to the original sources from the query layer and editing at the source is about the only way to do editing to your sources in combination with a query layer.&nbsp; However, the query layer will not automatically refresh to reflect the edits (performance is an issue for large joins, so the memory does not refresh automatically and usually you have to create the Query Table again to refresh it).&nbsp; All in all query layers are quite limited and mainly are useful for visualizing one-to-many and many-to-many relationships that have already been created at the source, but not much good for correcting errors or editing the sources.</SPAN></BODY></HTML> Mon, 05 Nov 2012 17:08:39 GMT https://community.esri.com/t5/data-management-questions/editing-query-layer/m-p/648418#M36701 RichardFairhurst 2012-11-05T17:08:39Z Re: Editing Query Layer https://community.esri.com/t5/data-management-questions/editing-query-layer/m-p/1213559#M44236 <P>Curious if there are any updates to this.</P> Fri, 16 Sep 2022 19:43:51 GMT https://community.esri.com/t5/data-management-questions/editing-query-layer/m-p/1213559#M44236 sofoo 2022-09-16T19:43:51Z