Error
The Create Database View tool does not accept the divide operator '/' in the view definition input field.
| Número de ID del error | BUG-000085841 |
|---|---|
| Enviado | March 4, 2015 |
| Última modificación | April 23, 2024 |
| Relacionado con | ArcSDE/Enterprise Geodatabase |
| Versión encontrada | 10.2.2 |
| Plataforma del servidor | Windows OS |
| Plataforma cliente | 10.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 March 1, 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. See Migrate from ArcMap to ArcGIS Pro for more information. https://www.esri.com/en-us/arcgis/products/arcgis-pro/resources/migrateSolución alternativa
- Create the view from the relational database management system (RDBMS) side. - Right-click the database connection in ArcCatalog > New > View. - Create the view using ArcSDESQLExecute. For example: import arcpy egdb = r"C:\Users\your-username\AppData\Roaming\ESRI\Desktop10.3\ArcCatalog\theconnection.sde" egdb_conn = arcpy.ArcSDESQLExecute(egdb) sql = ''' CREATE VIEW viewtest AS SELECT OBJECTID, 100/10 AS Price from DATAOWNER.TESTTABLE ''' egdb_return = egdb_conn.execute(sql) ArcSDESQLExecute: http://desktop.arcgis.com/en/arcmap/latest/analyze/arcpy-classes/arcsdesqlexecute.htmPasos para reproducir
ID del error: BUG-000085841
Software:
- ArcSDE/Enterprise Geodatabase
Obtener ayuda de expertos en ArcGIS
Descargar la aplicación de soporte de Esri
Descubrir más sobre este tema
Buscar información relacionada
Encontrar formación relacionada con este tema
Explorar ideas y aportar opiniones