laptop and a wrench

Bogue

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

Dernière publication: May 3, 2018 ArcGIS for Desktop
Numéro d’ID de bogue BUG-000096215
EnvoiMay 2, 2016
Dernière modificationJune 5, 2024
S’applique àArcGIS for Desktop
Version trouvée10.2.2
Système d’exploitationWindows OS
Version du système d’exploitation7.0 64 Bit
StatutWill Not Be Addressed

Informations supplémentaires

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

Solution de contournement

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.

Étapes pour reproduire

ID de bogue: BUG-000096215

Logiciel:

  • ArcGIS for Desktop

Recevoir une notification lorsque le statut d’un bogue change

Télécharger l’application Esri Support

En savoir plus sur ce sujet

Obtenir de l’aide auprès des experts ArcGIS

Contacter le support technique

Télécharger l’application Esri Support

Accéder aux options de téléchargement