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; } } }

can't see the updates in Arcmap only back end in SQL

LC27

Hello,

I updated a field (gs_phase) for all the records in one data layer. I did it directly in SQL database since there are 14,000 records and it would take too long using ArcMAP.

I can see the field being populated with text values in SQL (see a snapshot_1) but not in ArcMap (see a snapshot _2). There it continues to have numerical values.

Anybody knows, why is that happening? How to make the changes visible directly in ArcMap?

I appreciate anybody's feedback.

Snapshot_2.GIF

Snapshot_1.GIF

451683331_122101975958422359_5707300847039235140_n.jpg

Trouver plus de publications taguées avec

Enterprise geodatabase

Databases

Data Formats

Accepted answers

All comments

Asrujit_SenGupta

Is that Feature Class registered as versioned?

How did you update the data from the database end? Which table/view was used to update the data?

Is there any domain/subtype applied on that field?

VinceAngelo

Please don't SHOUT in post titles. You actually reduce the number of folks willing to read your post by using ALL CAPS. You can edit the original post so it isn't as hard to read.

- V

LC27

Good Morning,

Thank you for your reply. Yes, the feature class (servicepoint) is versioned. Actually, what I learned so far is that in ArcMap (front end) I am working with a view (servicepoint_evw). However, when I updated the field on the database end, I updated the actual data 'servicepoint' that's a part of the view (along with a/d tables).

No, there's no domain/subtype applied on that field.

I guess, the question should be, if there's a safe way to modify the field from the database end that would translate to servicepoint_evw I see in the front end.

LC27

Didn't know all caps are considered shouting. Thanks for suggestion. I changed the title to small caps.

MarlonAmaya

Hi @LC27 ,

If you want to edit versioned data using SQL, you need to edit the version view (_evw) and not the table itself (i.e. base table). The following documentation provide a clear example on how to accomplish this.

https://desktop.arcgis.com/en/arcmap/latest/manage-data/using-sql-with-gdbs/edit-versioned-data-using-sql-sqlserver.htm

It includes examples on how to edit the DEFAULT version using the version view, or a specific edit version, or create a new version.

Marlon

Asrujit_SenGupta

When you create a Feature Class using ArcGIS, the Base/Business Table is created with the same name on the db end (servicepoint in your case). When you 'registered as versioned' the same feature class, the Versioned view (servicepoint_evw) and the delta tables (a- & d- tables) are created at that point of time.

As already suggested by Marlon below, use the Versioned View to edit using SQL from db end. That is the recommended way to edit from db end.

LC27

Super helpful. Thank you so much!

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

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