Row

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 can be support directly as a property, such as qualified field names that include periods, can be accessed using the setValue and getValue methods.

Method Overview

MethodExplanation
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)
ParameterExplanationData Type
field_name

The field from which the value will be accessed.

String
Return Value
Data TypeExplanation
Object

The field value.

isNull (field_name)
ParameterExplanationData Type
field_name

The field to be queried.

None
Return Value
Data TypeExplanation
Boolean

True if the field value is null.

setNull (field_name)
ParameterExplanationData Type
field_name

The field that will be set to null.

String
setValue (field_name, object)
ParameterExplanationData 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
from arcpy import env
import string

# Set the workspace
#
env.workspace = "C:/Data"

# Use row object to get and set field values
# 
cur = arcpy.UpdateCursor("Addresses.dbf", '"STATENAME" = \'Ariz\'' )

# Iterate through rows and update values
#
for row in cur:
    row.STATENAME = string.replace(row.STATENAME, "Ariz", "Arizona")
    cur.updateRow(row)

del cur, row

Related Topics


10/28/2011