AnsweredAssumed Answered

da.UpdateCurso: Where clause for geometry

Question asked by mbw@geus.dk on Feb 6, 2014
Latest reply on Feb 6, 2014 by mbw@geus.dk
Hi Forum

I have a versioned database, where I want to make short lines longer. So in Python I try to select the short lines like this
 >>> uCursor = arcpy.da.UpdateCursor(inFeatures, [ 'OID@', 'SHAPE@', 'GM_LABEL', 'GM_USER_DEF' ], 'SHAPE@LENGTH < 300' ) edit = arcpy.da.Editor(arcpy.env.workspace) edit.startEditing() edit.startOperation()

which goes without problems but on
line = uCursor.next()

I get this error
Runtime error  Traceback (most recent call last):   File "<string>", line 1, in <module> RuntimeError: Underlying DBMS error [ORA-04054: databaselink LENGTH does not exist ] [G100.geopoint_line]


I tried also this where clause, that works in ArcMap Select by attributes:
SHAPE.LEN < 300


Because there is also a field called SHAPE.LEN.
I tried with and without quotes with no success.

Is it possible at all to make a constraint based on geometry?

/Marianne

Outcomes