I have a script that has worked without issues when running against a file gdb, but am struggling to understand why it is not compatible as is for use with SQL gdb.
The error I get is
...line 31, in <module> cursor.updateRow(row)
NameError: name 'cursor' is not defined
import arcpy
from arcpy import env
workspace = env.workspace = r'Database Connections\mysql.default.sde'
fc = 'Ramps_Copy'
fields = ['BusStopsValue', 'City_and_PubValue', 'Commercial_ZoningValue', 'MedicalValue',
'Parks_RecValue', 'SchoolsValue', 'Social_ServValue', 'Ped_CollisionsValue']
edit = arcpy.da.Editor(workspace)
edit.startEditing(False, True)
edit.startOperation()
with arcpy.da.UpdateCursor(fc, fields) as cursor:
for row in cursor:
row[0] = arcpy.GetParameterAsText(0)
row[1] = arcpy.GetParameterAsText(1)
row[2] = arcpy.GetParameterAsText(2)
row[3] = arcpy.GetParameterAsText(3)
row[4] = arcpy.GetParameterAsText(4)
row[5] = arcpy.GetParameterAsText(5)
row[6] = arcpy.GetParameterAsText(6)
row[7] = arcpy.GetParameterAsText(7)
cursor.updateRow(row)
del row
del cursor
edit.stopOperation()
edit.stopEditing(True)
Any thoughts?
Paul