Summary
The Row object represents the row of a table. The Row object is returned from InsertCursor, SearchCursor, and UpdateCursor.
Discussion
The Row object dynamically support field names from the data source as read/write properties. Field names that cannot be supported directly as a property, such as qualified field names that include periods, can be accessed using the setValue and getValue methods.
Method Overview
Method | Explanation |
getValue (field_name) | Gets the field value. |
isNull (field_name) | Is the field value null. |
setNull (field_name) | Sets the field value to null. |
setValue (field_name, object) | Sets the field value. |
Methods
getValue (field_name)
Parameter | Explanation | Data Type |
field_name | The field from which the value will be accessed. | String |
Return Value
Data Type | Explanation |
Object | The field value. |
isNull (field_name)
Parameter | Explanation | Data Type |
field_name | The field to be queried. | None |
Return Value
Data Type | Explanation |
Boolean | True if the field value is null. |
setNull (field_name)
Parameter | Explanation | Data Type |
field_name | The field that will be set to null. | String |
setValue (field_name, object)
Parameter | Explanation | Data Type |
field_name | The field that will be set to the new value. | String |
object | The value used to set the field value. | Object |
Code sample
Row example
Use update cursor to fetch row from feature class, update field value and row, iterating through rows in cursor.
import arcpy
# Set the workspace
arcpy.env.workspace = "c:/data"
# Use row object to get and set field values
cursor = arcpy.UpdateCursor("Addresses.dbf", '"STATENAME" = \'Ariz\'' )
# Iterate through rows and update values
for row in cursor:
row.setValue("STATENAME", "Arizona")
cursor.updateRow(row)
del cursor, row