laptop and a wrench

Bug

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

Zuletzt veröffentlicht: March 25, 2015 ArcSDE/Enterprise Geodatabase
Bug-ID-Nummer BUG-000085841
EingereichtMarch 4, 2015
Zuletzt geändertApril 23, 2024
Gilt fürArcSDE/Enterprise Geodatabase
Gefunden in Version10.2.2
Server-PlattformWindows OS
Client-Plattform10.0 64 Bit
StatusWill Not Be Addressed

Zusätzliche Informationen

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

Workaround

- 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

Schritte zur Reproduzierung

Bug-ID: BUG-000085841

Software:

  • ArcSDE/Enterprise Geodatabase

Hilfe von ArcGIS-Expert*innen erhalten

Technischen Support kontaktieren

Die Esri Support-App herunterladen

Zu den Download-Optionen

Weitere Informationen zu diesem Thema erkunden