VP Get row count

Home

4D v19

VP Get row count


VP Get row count ( vpAreaName {; sheet} ) -> Function result

Parameter	Type	Description
vpAreaName	Text	4D View Pro area from object name
sheet	Longint	Sheet index (current sheet if omitted)
Function result	Longint	Total number of rows

Description

The VP Get row count command returns the total number of rows from the designated sheet.

In vpAreaName, pass the name property of the 4D View Pro area. If you pass a name that does not exist, an error is returned.

You can define where to get the row count in the optional sheet parameter using the sheet index (counting begins at 0). If omitted, the current spreadsheet is used by default. You can explicitly select the current spreadsheet with the following constant:

Constant	Type	Value	Comment
vk current sheet	Longint	-1	Designates current sheet of the 4D View Pro area (default)

Example

The following code returns the number of rows in the 4D View Pro area:

 C_LONGINT($rowCount)

 $rowCount:=VP Get row count("ViewProarea")