I am attempting to edit a multiversioned view using SQL. I set the feature class to versioned, created the view from command line using "sdetable -o create_mv_view", and try to run an update with SQL on a single attribute field but receive the error:
Msg 50000, Level 16, State 1, Procedure v446_update, Line 27
User must call edit_version before editing the view.
If I try to call edit_version I get:
Msg 50000, Level 16, State 1, Procedure edit_version, Line 78
Cannot edit the DEFAULT version in STANDARD transaction mode.
I am running ArcGIS and ArcSDE 10.0 SP3 on SQL Server 2008. The ability to edit the Default version through multiversioned views is available at version 10 SP2 according to http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/A_quick_tour_of_editing_versioned_data_using_SQL/006z000000vp000000/.
http://support.esri.com/en/knowledgebase/techarticles/detail/39112 describes this behavior also. Not specifying an edit version still gives me the first error above.
Just to be sure, I removed all other versions, compressed to state 0, unversioned the feature class, reverionsed, and recreated the view, but still have the same problem.
Does anyone successfully use views in this way and what version is the server running? Is the documentation wrong?