Returns the number of rows in a rowset, respecting any filter conditions and events.

Syntax

<oRef>.count( )

<oRef>

The rowset you want to measure.

Property of

Rowset

Description

count( ) returns the number of rows in the current rowset. For a rowset generated by a simple query like the following, which selects all the fields from a single table with no conditions, count( ) returns the number of rows in the table:

select * from CUSTOMER

You can use count( ) while a filter is active—with the filter property or the canGetRow event—to count the number of rows that match the filter condition. This may be time-consuming with large rowsets.