RowCount

Description

Obtains the number of rows that are currently available in a DataWindow control or DataStore. To determine the number of rows available, the RowCount method checks the primary buffer.

Applies to

DataWindow type	Method applies to
PowerBuilder	DataWindow control, DataWindowChild object, DataStore object
Web	Client control, server component
Web ActiveX	DataWindow control, DataWindowChild object

Syntax

PowerBuilder and Web DataWindow server component

long dwcontrol.RowCount ( )

Web DataWindow client control and Web ActiveX

number dwcontrol.RowCount ( )

Argument	Description
dwcontrol	A reference to a DataWindow control, DataStore, or child DataWindow

Returns

Returns the number of rows that are currently available in dwcontrol, 0 if no rows are currently available, and –1 if an error occurs.

If dwcontrol is null, in PowerBuilder and JavaScript the method returns null.

Usage

The primary buffer for a DataWindow control or DataStore contains the rows that are currently available for display or printing. These are the rows counted by RowCount. The number of currently available rows equals the total number of rows retrieved minus any deleted or filtered rows plus any inserted rows. The deleted and filtered rows are stored in the DataWindow’s delete and filter buffers.

Examples

Example 1

This statement returns the number of rows currently available in dw_Employee:

long NbrRows

NbrRows = dw_Employee.RowCount()

Example 2

This example determines when the user has scrolled to the end of a DataWindow control. It compares the row count with the DataWindow property LastRowOnPage:

dw_1.ScrollNextPage()

IF dw_1.RowCount() = Integer(dw_1.Describe( &

			"DataWindow.LastRowOnPage")) THEN

		... // Appropriate processing

END IF