laptop and a wrench

漏洞

Using a forward slash (/) in the SELECT query for the view definition in the Create Database View geoprocessing tool returns an error.

上次发布: May 3, 2018 ArcGIS for Desktop
漏洞 ID 编号 BUG-000096215
已提交May 2, 2016
上次修改时间June 5, 2024
适用范围ArcGIS for Desktop
找到的版本10.2.2
操作系统Windows OS
操作系统版本7.0 64 Bit
状态Will Not Be Addressed

附加信息

ArcGIS Desktop (including ArcGIS Engine and ArcObjects) is in mature support and will be retired on March 1st, 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. Refer to 'Migrate from ArcMap to ArcGIS Pro' for more information: https://www.esri.com/en-us/arcgis/products/arcgis-pro/resources/migrate

解决办法

Possible workarounds using the Create Database View geoprocessing tool:

Use (* 0.5) instead of (/2). Users can always replace with a divisible factor to suit their query. For example,

select OBJECTID,OBJECTID/0.5 AS TESTCOLUMN, SHAPE from TEST.DBO.Featureclass.

Or

Use the ROUND() function to round it up to whole number if users do not want to work with floats. For example, 

​select OBJECTID,ROUND(OBJECTID/0.5,0) AS TESTCOLUMN, SHAPE from TEST.DBO.Featureclass.

重现步骤

漏洞 ID: BUG-000096215

软件:

  • ArcGIS for Desktop

当漏洞状态发生变化时获得通知

下载 Esri 支持应用程序

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

获取来自 ArcGIS 专家的帮助

联系技术支持部门

下载 Esri 支持应用程序

转至下载选项