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 |
Syntax
PowerBuilder
long dwcontrol.RowCount ( )
Return value
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
This statement returns the number of rows currently available in dw_Employee:
long NbrRows NbrRows = dw_Employee.RowCount()
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 IFSee also
