Bug
Using a forward slash (/) in the SELECT query for the view definition in the Create Database View geoprocessing tool returns an error.
| Bug ID Number | BUG-000096215 |
|---|---|
| Submitted | May 2, 2016 |
| Last Modified | June 5, 2024 |
| Applies to | ArcGIS for Desktop |
| Version found | 10.2.2 |
| Operating System | Windows OS |
| Operating System Version | 7.0 64 Bit |
| Status | Will 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/migrateWorkaround
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
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App