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 cursor.updateRow(row) NameError: name 'cursor' is not defined # Import system modules import arcpy from arcpy import env # Set workspace and declare variables 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' ] # Start edit session edit = arcpy . da . Editor ( workspace ) edit . startEditing ( False , True ) edit . startOperation ( ) # Set values to update with arcpy . da . UpdateCursor ( fc , fields ) as cursor : for row in cursor : # Assign values to categories row [ 0 ] = arcpy . GetParameterAsText ( 0 ) # Bus Stops row [ 1 ] = arcpy . GetParameterAsText ( 1 ) # City & Public Facilities row [ 2 ] = arcpy . GetParameterAsText ( 2 ) # Commercial Zoning row [ 3 ] = arcpy . GetParameterAsText ( 3 ) # Medical Facilities row [ 4 ] = arcpy . GetParameterAsText ( 4 ) # Parks & Rec row [ 5 ] = arcpy . GetParameterAsText ( 5 ) # Schools row [ 6 ] = arcpy . GetParameterAsText ( 6 ) # Social Services row [ 7 ] = arcpy . GetParameterAsText ( 7 ) # Pedestrian-Related Collisions cursor . updateRow ( row ) # Cleanup del row del cursor # Stop edit sesion edit . stopOperation ( ) edit . stopEditing ( True ) Any thoughts? Paul

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Update Cursor NameError

PaulStephenson

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

<SPAN class="comment token"># Import system modules</SPAN>
<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">from</SPAN> arcpy <SPAN class="keyword token">import</SPAN> env


<SPAN class="comment token"># Set workspace and declare variables</SPAN>
workspace <SPAN class="operator token">=</SPAN> env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'Database Connections\mysql.default.sde'</SPAN>

fc <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Ramps_Copy'</SPAN>
fields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'BusStopsValue'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'City_and_PubValue'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Commercial_ZoningValue'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'MedicalValue'</SPAN><SPAN class="punctuation token">,</SPAN>
          <SPAN class="string token">'Parks_RecValue'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'SchoolsValue'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Social_ServValue'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Ped_CollisionsValue'</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token"># Start edit session</SPAN>
edit <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>Editor<SPAN class="punctuation token">(</SPAN>workspace<SPAN class="punctuation token">)</SPAN>
edit<SPAN class="punctuation token">.</SPAN>startEditing<SPAN class="punctuation token">(</SPAN><SPAN class="token boolean">False</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">)</SPAN>
edit<SPAN class="punctuation token">.</SPAN>startOperation<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>


<SPAN class="comment token"># Set values to update</SPAN>
<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> fields<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
        <SPAN class="comment token"># Assign values to categories</SPAN>
        row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetParameterAsText<SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN>  <SPAN class="comment token"># Bus Stops</SPAN>
        row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetParameterAsText<SPAN class="punctuation token">(</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN>  <SPAN class="comment token"># City & Public Facilities</SPAN>
        row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetParameterAsText<SPAN class="punctuation token">(</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">)</SPAN>  <SPAN class="comment token"># Commercial Zoning</SPAN>
        row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetParameterAsText<SPAN class="punctuation token">(</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">)</SPAN>  <SPAN class="comment token"># Medical Facilities</SPAN>
        row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetParameterAsText<SPAN class="punctuation token">(</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">)</SPAN>  <SPAN class="comment token"># Parks & Rec</SPAN>
        row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">5</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetParameterAsText<SPAN class="punctuation token">(</SPAN><SPAN class="number token">5</SPAN><SPAN class="punctuation token">)</SPAN>  <SPAN class="comment token"># Schools</SPAN>
        row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetParameterAsText<SPAN class="punctuation token">(</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">)</SPAN>  <SPAN class="comment token"># Social Services</SPAN>
        row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">7</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetParameterAsText<SPAN class="punctuation token">(</SPAN><SPAN class="number token">7</SPAN><SPAN class="punctuation token">)</SPAN>  <SPAN class="comment token"># Pedestrian-Related Collisions</SPAN>
        cursor<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>

        <SPAN class="comment token"># Cleanup</SPAN>
        <SPAN class="keyword token">del</SPAN> row
        <SPAN class="keyword token">del</SPAN> cursor


<SPAN class="comment token"># Stop edit sesion</SPAN>
edit<SPAN class="punctuation token">.</SPAN>stopOperation<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
edit<SPAN class="punctuation token">.</SPAN>stopEditing<SPAN class="punctuation token">(</SPAN><SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">)</SPAN>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Any thoughts?

Paul

Trouver plus de publications taguées avec

Accepted answers

JoshuaBixby

Not sure if it is a copy/paste artifact, but Line #35 outdented. You are deleting the cursor after the first record. Does that fix it?

All comments

PaulStephenson

Indeed that was it. I must have bumped that bit in at some point without realizing it and was looking at everything but that.

Thanks again, much appreciated.

PaulStephenson

Thanks for the second set of eyes Joshua. I bet you're right, will give it a shot this evening. Not sure but it may have been like this yet still running against the file gdb...will look at that as well.

JoshuaBixby

Not sure if it is a copy/paste artifact, but Line #35 outdented. You are deleting the cursor after the first record. Does that fix it?

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.