I want to update a record with a sequential number. Every time the user adds a record, the sequence attribute increases by 1. So record digitized for the first time has a sequence number of 1, the second record gets a sequence number of 2, etc. The record has to be selected when this update occurs. The sequence field is of data type number, but I could create a string attribute if necessary. I tried the following but keeps getting a 1 for all the records. What am I doing wrong? Thank you!!!
filter = 'NOT Sequence IS NULL' #filter for non-Null values
cur1 = arcpy.UpdateCursor("Stewardship", filter)
# Iterate through rows and get highest ID values
high_id = 0
for row1 in cur1:
if high_id < row1.Sequence:
high_id = row1.Sequence
filter = 'Sequence IS NULL' #filter for Null values
cur2 = arcpy.UpdateCursor("Stewardship", filter)
# Iterate through rows and update values
i = high_id
for row2 in cur2:
i += 1
row2.Sequence = i
cur2.updateRow(row2)