laptop and a wrench

漏洞

The Create Database View tool does not accept the divide operator '/' in the view definition input field.

上次发布: March 25, 2015 ArcSDE/Enterprise Geodatabase
漏洞 ID 编号 BUG-000085841
已提交March 4, 2015
上次修改时间April 23, 2024
适用范围ArcSDE/Enterprise Geodatabase
找到的版本10.2.2
服务器平台Windows OS
客户端平台10.0 64 Bit
状态Will Not Be Addressed

附加信息

ArcGIS Desktop (including ArcGIS Engine and ArcObjects) is in mature support and will be retired March 1, 2026. Mature support means the end of functionality-based patches and hotfixes; therefore, this issue will not be addressed. There are no plans for future releases of ArcGIS Desktop, and it is recommended to migrate to ArcGIS Pro. See Migrate from ArcMap to ArcGIS Pro for more information. https://www.esri.com/en-us/arcgis/products/arcgis-pro/resources/migrate

解决办法

- Create the view from the relational database management system (RDBMS) side. - Right-click the database connection in ArcCatalog > New > View. - Create the view using ArcSDESQLExecute. For example: import arcpy egdb = r"C:\Users\your-username\AppData\Roaming\ESRI\Desktop10.3\ArcCatalog\theconnection.sde" egdb_conn = arcpy.ArcSDESQLExecute(egdb) sql = ''' CREATE VIEW viewtest AS SELECT OBJECTID, 100/10 AS Price from DATAOWNER.TESTTABLE ''' egdb_return = egdb_conn.execute(sql) ArcSDESQLExecute: http://desktop.arcgis.com/en/arcmap/latest/analyze/arcpy-classes/arcsdesqlexecute.htm

重现步骤

漏洞 ID: BUG-000085841

软件:

  • ArcSDE/Enterprise Geodatabase

从 ArcGIS 专家处获得帮助

联系技术支持部门

下载 Esri 支持应用程序

转至下载选项

发现关于本主题的更多内容