RecordCount Property

See Also

OraDynaset Example

OraSQLStmt Example

Applies To

OraDynaset

OraSQLStmt

Description

For the OraDynaset object, RecordCount returns the total number of records in the dynaset.

For the OraSQLStmt object, RecordCount returns the number of records processed in an insert, update, or delete statement, even when there is a failure executing the SQL statement.

Not available at design time and read-only at run time.

Usage

record_count = oradynaset.RecordCount

record_count = orasqlstmt.RecordCount

Remarks

Referencing this property requires that the entire result table be fetched immediately from Oracle in order to determine the count of records. Due to the potentially severe performance impact of this, the user should avoid using this property and instead execute an additional query using the "COUNT(*)" clause, and use the SnapshotID property to guarantee time consistency. For an example of this, see the SnapShot property.

Referencing this property while using the ORADYN_NOCACHE option of the CreateDynaset method causes an implicit MoveLast and makes the current record the last record in the dynaset.

Data Type

Long Integer