IWorkspace.ExecuteSQL does not work?

Anonymous User

Hi

I tried to update a layer as below:
                    IWorkspaceProperties pp = mVersionedFeatureWorkspace as IWorkspaceProperties;
                    IWorkspaceProperty ap = pp.get_Property(esriWorkspacePropertyGroupType.esriWorkspacePropertyGroup, (int)esriWorkspacePropertyType.esriWorkspacePropCanExecuteSQL);
                    bool abc = ap.IsSupported;

                    if (abc)
                    {
                        IWorkspace pw = mVersionedFeatureWorkspace as IWorkspace;
                        pw.ExecuteSQL("update rwline set MaterialType = 4 where gid= 987654321");
                    }

the sql statement can be run without error, but unfortunately it also changed nothing. no specific record has been updated.

Is there something wrong I have?

Thank you.

Anonymous User

Hi Bing,

To work on a version with SQLExecute you'll first need to set the versioned view via a stored procedure in your DBMS, otherwise it will only see the base table. 

The following topics explain how to access geodatabase data with SQL and versioned views (previously called multiversioned views)

SQL access to enterprise geodatabase data—ArcMap | Documentation 

What is a versioned view?—ArcMap | Documentation