Update Cursor infinite loop

SusieGreen

Hello everyone,

I am a python newbie and trying to update a field in a table based on a field in a feature class. The table already contains unique id's that have to match the id's in the feature class.
What happens with the code below is that it goes in an infinite loop where it writes just the first value from the feature class in all the table rows.
Any help would be greatly appreciated.

# write Value to Table         # search cursor         scurs = arcpy.SearchCursor(infc)         # update cursor         ucurs = arcpy.UpdateCursor(tbl)         for scur in scurs:             newRow = scur.getValue("ID")             while newRow <> 0:                 for ucur in ucurs:                     ucur.Value = scur.getValue("Value")                     # update row                     ucurs.updateRow(ucur)

jskinner

The problem before was that the dictionary was not sorted correctly.  You can do this one of two ways.

1.  Using an a data dictionary with an updateCursor:

table = "Basins.dbf" fc = "Watersheds.shp"  fcDict = {}  rows = arcpy.SearchCursor(fc, "", "", "", "ID A") for row in rows:     fcDict[row.ID] = row.Value del rows, row  x = 0  rows = arcpy.UpdateCursor(table, "", "", "", "ID A") for row in rows:     if row.ID == sorted(fcDict):         row.Value = fcDict[row.ID]         rows.updateRow(row)         print "Successfully updated row"     x += 1 del rows, row

2.  Create a Join and then calculate values using the Field Calculator:

table = "Basins.dbf" fc = "Watersheds.shp"  arcpy.MakeTableView_management(table, "Basins_view") arcpy.AddJoin_management("Basins_view", "ID", fc, "ID")  arcpy.CalculateField_management("Basins_view", "basins.Value", "[watersheds.Value]")