Oracle Objects for OLE
Release 9.0.1

Part Number A90173-01

Home

Book List

Contents

Master Index

Feedback

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


 
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.

Home

Book List

Contents