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.

Zuletzt veröffentlicht: May 3, 2018 ArcGIS for Desktop
Bug-ID-Nummer BUG-000096215
EingereichtMay 2, 2016
Zuletzt geändertJune 5, 2024
Gilt fürArcGIS for Desktop
Gefunden in Version10.2.2
BetriebssystemWindows OS
Betriebssystemversion7.0 64 Bit
StatusWill Not Be Addressed

Zusätzliche Informationen

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.

Schritte zur Reproduzierung

Bug-ID: BUG-000096215

Software:

  • ArcGIS for Desktop

Benachrichtigung erhalten, wenn sich der Status eines Bugs ändert

Esri Support App herunterladen

Weitere Informationen zu diesem Thema erkunden

Unterstützung durch ArcGIS-Experten anfordern

An den technischen Support wenden

Esri Support App herunterladen

Zu Download-Optionen wechseln