I am attempting to update a FeatureClass's property using a SQL query. (DB version is 10.3.1) Such as:
UPDATE <versioned_view> SET <field> = <value> WHERE objectid = 1;
However, each time I receive the following error:
"User must call edit_version before editing the view."
I have found that the reason for this is because the feature class in question stores it's spatial data in Esri's binary format (Thanks to this other forum post).
I know it is possible to migrate data formats, but I'm wondering how safe this operation is. New features are added to our database daily using ArcMap by our mapping team, and our ArcGIS rest service is constantly being queried. Making a breaking change to storage formats would be a big problem.
Is there a way to update a property using SQL without changing the spatial data storage type?
Note: This question is basically a continuation of my previous question.
Thanks in advance, this forum as been so incredibly help as I try and figure out how ArcGIS works.
- Daniel