FAQ:  Can users edit delta tables using ArcObjects?

相关信息
Article ID: 42343
Software:
ArcGIS for Desktop Advanced 10.1, 10.2, 10.2.1, 10.2.2
ArcGIS for Desktop Standard 10.1, 10.2, 10.2.1, 10.2.2
ArcObjects SDK for the Microsoft .NET Framework 10.0, 10.1, 10.2
ArcObjects SDK for cross platform C++ Windows 10.0, 10.1
ArcObjects SDK for cross platform C++ Linux 10.0, 10.1
ArcObjects SDK for Java Linux 10.0, 10.1
ArcObjects SDK for Java Windows 10.0, 10.1
Platforms: N/A

问题描述
Can users edit delta tables using ArcObjects?
已邀请:

EsriSupport

赞同来自:

解决方案
No. Users cannot edit delta tables using ArcObjects as there are no ArcObjects interfaces available for them to do so.

However, they can use structured query language (SQL) to query a versioned view to edit the data in the delta tables. Users can edit delta tables from ArcObjects and Python using SQL queries against the database. This method must be used since users are not allowed to directly edit RDBMS tables that are not registered to a database.

In ArcObjects users can open the SQL workspace using information from the following pages:
Working with SQL workspaces and
IWorkspace Interface. Once the user is connected to the SQL database, they can execute their SQL queries against the delta tables using the IWorkspace.ExecuteSQL method.

In Python, users can execute SQL queries using an ArcSDE connection. Refer to the following
ArcGIS Web Help topic for more information on how to execute SQL using an ArcSDE connection.



Delta tables are geodatabase system tables that record version changes. This is how ArcGIS supports versioning capabilities. For each table or feature class that has been versioned, two new delta tables, an 'adds' and a 'deletes' table, are created in the database. The delta tables record any inserts, updates, or deletes made to a versioned table or feature class at each state of the database.


创建及修改时间
Created: 3/20/2014

Last Modified: 7/21/2014
原文链接
http://support.esri.com/en/kno ... 42343

要回复问题请先登录注册