laptop and a wrench

Erro

The Create Database View tool does not accept the divide operator '/' in the view definition input field.

Última Publicação: March 25, 2015 ArcSDE/Enterprise Geodatabase
Número de ID do Erro BUG-000085841
EnviadoMarch 4, 2015
Última ModificaçãoApril 23, 2024
Aplica-se àArcSDE/Enterprise Geodatabase
Versão encontrada10.2.2
Plataforma do servidorWindows OS
Plataforma do cliente10.0 64 Bit
StatusWill Not Be Addressed

Informações Adicionais

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/migrate

Solução Provisória

- 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.htm

Etapas para Reproduzir

ID do Erro: BUG-000085841

Software:

  • ArcSDE/Enterprise Geodatabase

Obtenha ajuda de especialistas do ArcGIS

Entre em contato com suporte técnico

Baixe o Esri Support App

Ir para opções de download

Descubra mais sobre este tema