Error
Using a forward slash (/) in the SELECT query for the view definition in the Create Database View geoprocessing tool returns an error.
| Número de ID del error | BUG-000096215 |
|---|---|
| Enviado | May 2, 2016 |
| Última modificación | June 5, 2024 |
| Relacionado con | ArcGIS for Desktop |
| Versión encontrada | 10.2.2 |
| Sistema operativo | Windows OS |
| Versión de sistema operativo | 7.0 64 Bit |
| Estado | Will Not Be Addressed |
Información adicional
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/migrateSolución alternativa
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.
Pasos para reproducir
ID del error: BUG-000096215
Software:
- ArcGIS for Desktop
Recibir notificaciones cuando cambie el estado de un error
Descubrir más sobre este tema
Buscar información relacionada
Encontrar formación relacionada con este tema
Explorar ideas y aportar opiniones
Obtener ayuda de expertos en ArcGIS
Descargar la aplicación de soporte de Esri