Applies To
OraDynasetOraSQLStmtDescription
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