Debugging Cursor object has no attribute _exit_ from ArcPy?

Question

I am trying to replace NULL values for -999 in a table inside a gdb. I know how to replace the value for individual fields, but get an error when looping through the complete table.

import arcpy
fc ="C:\gSSURGO.gdb\chorizon_va_1"
fieldList = arcpy.ListFields(fc)

with arcpy.UpdateCursor(fc, [fieldList]) as cursor:
 fRange = range(len(fieldList)) 
 for row in cursor:

     for index in fRange:
         if row[index] == None:
             row[index] = -999 
     cursor.updateRow(row)

And this is the error I get:

Runtime error : 'Cursor' object has no attribute '_exit_'

I found some examples using arcpy.da.UpdateCursor, but when I use that I get this error:

Runtime error <type 'exceptions.AttributeError'>: 'module' object has no attribute 'da'

I am using ArcMap 10.0.

Answer 1

ArcPy did not have a Data Access module until ArcGIS 10.1. This will explain your second error message.

The only way to specify fields in ArcPy cursors prior to that was by using their names rather than an index.

Answer 2

I updated to ArcMap 10.2.

This worked for all types of fields:

import arcpy

fc ="C:\gSSURGO_test.gdb\chor_comp_zone1"
fieldObs = arcpy.ListFields (fc)
fieldNames = [] 

for field in fieldObs:
    fieldNames.append(field.name)  

fieldCount = len(fieldNames)

curU = arcpy.da.UpdateCursor(fc, fieldNames)
for row in curU:
         rowU = row 
         for field in range(fieldCount):
                      if rowU[field] == None:
                         rowU[field] = -999
         curU.updateRow(rowU)