laptop and a wrench

Bug

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

Last Published: May 3, 2018 ArcGIS for Desktop
Bug ID Number BUG-000096215
SubmittedMay 2, 2016
Last ModifiedJune 5, 2024
Applies toArcGIS for Desktop
Version found10.2.2
Operating SystemWindows OS
Operating System Version7.0 64 Bit
StatusWill Not Be Addressed

Additional Information

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

Workaround

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.

Steps to Reproduce

Bug ID: BUG-000096215

Software:

  • ArcGIS for Desktop

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options