Row

概要

The Row object represents the row of a table. The Row object is returned from InsertCursor, SearchCursor, and UpdateCursor.

ディスカッション

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.

手法の概要

手法説明
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.

手法

getValue (field_name)
パラメーター説明データ タイプ
field_name

The field from which the value will be accessed.

String
戻り値
データ タイプ説明
Object

The field value.

isNull (field_name)
パラメーター説明データ タイプ
field_name

The field to be queried.

None
戻り値
データ タイプ説明
Boolean

True if the field value is null.

setNull (field_name)
パラメーター説明データ タイプ
field_name

The field that will be set to null.

String
setValue (field_name, object)
パラメーター説明データ タイプ
field_name

The field that will be set to the new value.

String
object

The value used to set the field value.

Object

コードのサンプル

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

関連トピック