nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to Edit a Query Layer

NareshNagandla

HI,

I have created a Query Layer which queries against my Oracle Database. I am only able to view the data but I cannot edit the data directly in ArcGIS PRO 2.3. When I click on EDIT tab in ArcGIS and click the point, it disables the Modify or Delete and I cannot make any changes.

When creating the connection to database, I have used a user which has both Read and Write permissions.

Can Someone please let me know what I am doing wrong here??

Vind meer berichten getagd met

Accepted answers

All comments

sofoo

I really don't see why there'd be any issue editing any part of a query layer. It should just cascade the edits to the base table, just like when you update an _evw view in SDE. Would also like this functionality. I'm experimenting with SQL Spatial's ability to store multiple shape types in one table.

Natalie_Runyan

Hi Naresh, did you ultimately discover a way to edit via a query layer? for years we have published read-only services of our non-SDE/RDBMS data, even as feature services for taking into offline workflows. However, we've never actually attempted to edit the records from the GIS side. We'd like to do that now, just for attributes not the geometry field. I can understand that the geometry would not be editable because that is what is used to create the query layer in the first place (it would be a circular logic problem I think). I'm thinking maybe we could use an "update" statement instead of a "select" to actually create the query layer?

NareshNagandla

I am using ArcGIS Pro 2.3.0

Created a QueryLayer

On selecting a particular attribute on Map and select Edit Ribbon and Click Modify and then select Move

I am unable to move the point to a different Coordinate:

Where as on a File Geodatabase, I can Modify and click Move and Change the Co-ordinates.

Only on an Query Layer which was connected to enterprise GeoDatabase, I am unable to do it.

JonathanFarmer_oldaccount

Can you try going through this workflow to create the query layer and see if it lets you edit? I just tried your exact query here and it works fine for me. Are you using Pro 2.3.3 or 2.3.0?

https://pro.arcgis.com/en/pro-app/help/data/query-layers/creating-a-query-layer.htm

NareshNagandla

I am using a simple select query only.

select * from STRUCTURE where deleted = 'N'

JonathanFarmer_oldaccount

Hi Naresh,

Is this just a simple query to 1 underlying table?

If I do a "select * from table" and use that to create a new query layer, I can modify and delete features in Pro. But if you are doing a more complex query with a join or other behavior, that could be playing a role here.

Can you include the query you are using? How are you creating the query layer?

Jonathan

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.