IRow Interface

Provides access to members that return information about the row, the table the row belongs to and storing and deleting the row.

Description

An instance of the Row object represents a persistent row in a Table. A row object is normally obtained from a cursor on a table (for example, ICursor::NextRow) or fetched directly using its Object ID (for example, ITable::GetRow).

Once retrieved, clients may query the row object for additional interfaces and invoke methods on the row object. The CLSID property of a Table determines the type of row object returned by the Table.

A new persistent row object is created using the ITable::CreateRow method. The act of creating a row assigns it identity.

A row has a set of fields. The set of fields for a row is the same as the set of fields for its table. In particular, the numeric index of a field in a table's fields collection is the same as the numeric index of the field in the row's fields collection. This means that application programs can and should cache field numeric indexes using the FindField method on table, rather than invoking the FindField method for each row returned by a Cursor.

Members

Name Description
Method Delete Deletes the row.
Read-only property Fields The fields Collection for this row buffer.
Read-only property HasOID Indicates if the row has an OID.
Read-only property OID The OID for the row.
Method Store Stores the row.
Read-only property Table The Table for the row.
Read/write property Value The value of the field with the specified index.

IRow.Delete Method

Deletes the row.

Public Sub Delete ( _
)
public void Delete (
);

Remarks

All edits to features that participate in a Topology or Geometric Network must be performed within an edit session and bracketed within an edit operation.

IRow.HasOID Property

Indicates if the row has an OID.

Public ReadOnly Property HasOID As Boolean
public bool HasOID {get;}

Remarks

If the table has been registered with the geodatabase it will have unique Object ID, automatically created by the register tool, and the HasOIDproperty will be set to True. Tables not registered with the geodatabase will not have an OID column and the HasOID property will be set to False. See the IClassSchemaEdit::RegisterAsObjectClass method for more information.

IRow.OID Property

The OID for the row.

Public ReadOnly Property OID As Long
public long OID {get;}

Description

Gets the OIDfor a row in a table that has a unique Object ID, such as tables registered with the geodatabase.

IRow.Store Method

Stores the row.

Public Sub Store ( _
)
public void Store (
);

Errors Returned

FDO_E_OBJECTCLASS_REQUIRES_AN_EDIT_SESSION: When Store is called on a network feature when the data is unversioned or an edit session has not been started.

FDO_E_CANNOT_SET_WEIGHT_FIELD: When Store is called on a network edge feature with a weight field associated with Shape_Length, on unversioned data or when an edit session has not been started.

FDO_E_FEATURE_NO_GEOMETRY: When Store is called on a network feature or feature in a topology with empty geometry.

SDE_E_SE_STATE_CLOSED: When Store is called on a feature in a versioned feature class within an edit session, but outside of an edit operation. The error description returned will be "The requested operation is invalid on a closed state [name of class]"

Remarks

The Store method is called by an application once it has modified the values of a Row. Once Store is called on a Row object, all subsequent queries within the same edit session, using the Geodatabase API, will reflect the modified state of the Row object.

All edits to features that participate in a Topology or Geometric Network must be performed within an edit session and bracketed within an edit operation.

Calling the Store method triggers the following actions:

- The IRowEvents::OnChanged is called for the row being stored. The OnNew is called if this is a newly created row being stored for the first time. A custom row object can implement the OnChanged method and take some special action when it is called - for example; update a special column in the row

- The IRelatedObjectEvents::RelatedObjectChanged method is called for related objects in a related object class if the table for this row is an object class that participates in relationship classes with notification

Store should not be used for batch operations, such as updates or inserts. For performing a number of inserts or updates using cursors, refer to the ITable::Insert, ITable::Update, ITable::UpdateSearchedRows , IFeatureClass::Update andIFeatureClass::Insert. If an insert or update cursor is used on non-simple features (such as network features), the cursor will revert to using Store.

It is not necessary to explicitly call Connect on network features, this is handled polymorphically when Store is called on the feature. This is also the case with features in a Topology, Dirty Area creation is handled internally when Store is called.

Store should not be called inside of edit events, such as OnCreateFeature, OnChangeFeature or OnDeleteFeature. Even if you are modifying the geometry or other field values, Store will be called once the event is complete.

IRow.Table Property

The Table for the row.

Public ReadOnly Property Table As ITable
public ITable Table {get;}

Description

Returns a pointer to the table the row belongs to.

Inherited Interfaces

Interfaces Description
IRowBuffer Provides access to members used for getting and modifying a rows values and for getting the fields in the row.

Classes that implement IRow

Classes Description
Feature Esri Feature.

Remarks

The IRow interface inherits from the IRowBuffer interface and includes properties and methods to get and set the row's values, detect whether the row has an Object ID (and retrieve it, if it does has one), get the row's table, delete the row, and persist any changes made to the row.

The OID property returns the unique object identifier for the Row that distinguishes it from other rows in the table. If the HasOID property returns false, then this row was returned from a table lacking a geodatabase-managed Object ID field. This generally occurs when the table is not registered with the geodatabase; see the IClassSchemaEdit::RegisterAsObjectClass method for more information.

The Store method is called by an application once it has modified the values of a Row. Calling the Store method triggers the following actions.

  1. The IRowEvents::OnChanged method is called for the Row being stored (the OnNew method is called if this is a newly created row being stored for the first time). A custom row object can implement the RowEvents::OnChanged method and take some special action when it is called—for example, update a special column in the row.
  2. The IRelatedObjectEvents::RelatedObjectChanged method is called for related objects in related object class if the table for this row is an object class that participates in relationship classes with notification.

Once Store is called on a Row object, all subsequent queries against the table within the same edit session using the geodatabase API will reflect the modified state of the row object.

The Delete method is called by an application to delete a row object from the database. Calling the Delete method triggers the following actions.

  1. The IRowEvents::OnDelete method is called for the Row being deleted. A custom row object can implement the IRowEvents::OnDelete method and take some special action when it is called.
  2. All relationships in which the row object participates are automatically deleted.

Once Delete is called on a Row object, all subsequent queries against the Table within the same edit session using the geodatabase API will reflect the deleted state of the row object.

The changes made to a row object using the Store and Delete methods will be committed to persistent store if the containing edit session is saved and no conflicts are detected. If the changes were made outside of an edit session, then the application program is responsible for directly managing underlying database transactions using the ITransactions interface on the Workspace.

This example shows the creation of a row, then an update, followed by it being deleted.

    //e.g., nameOfField = "FruitName";

     public void IRow__(ITable table, string nameOfField)

     {

         int fieldIndex = table.FindField(nameOfField);

         //insert row

         IRow row = table.CreateRow();

         //initalize all of the default field values for the new row.

         IRowSubtypes rowSubTypes = (IRowSubtypes)row;

         rowSubTypes.InitDefaultValues();

         row.set_Value(fieldIndex, "Banana");

         row.Store();

         //update row

         row.set_Value(fieldIndex, "Ripe Banana");

         row.Store();

         //delete row

         row.Delete();

     }

Your browser is no longer supported. Please upgrade your browser for the best experience. See our browser deprecation post for more details.