laptop and a wrench

Bogue

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

Dernière publication: March 25, 2015 ArcSDE/Enterprise Geodatabase
Numéro d’ID de bogue BUG-000085841
EnvoiMarch 4, 2015
Dernière modificationApril 23, 2024
S’applique àArcSDE/Enterprise Geodatabase
Version trouvée10.2.2
Plateforme serveurWindows OS
Plateforme client10.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 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

Solution de contournement

- 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

Étapes pour reproduire

ID de bogue: BUG-000085841

Logiciel:

  • ArcSDE/Enterprise Geodatabase

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

En savoir plus sur ce sujet