laptop and a wrench

Bug

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

Last Published: March 25, 2015 ArcSDE/Enterprise Geodatabase
Bug ID Number BUG-000085841
SubmittedMarch 4, 2015
Last ModifiedMay 31, 2023
Applies toArcSDE/Enterprise Geodatabase
Version found10.2.2
Operating SystemWindows OS
Operating System Version10.0 64 Bit
StatusIn Product Plan

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

Steps to Reproduce

Bug ID: BUG-000085841

Software:

  • ArcSDE/Enterprise Geodatabase

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback