Please enable JavaScript to view this site.

Navigation: Advanced topics > Events > Table events > List page

Get Row Count

Scroll Prev Next More

Deprecated

This function is deprecated. While the existing code keeps working, we recommend switching to SQL Views.

Description

The ListGetRowCount event is executed before the List page is processed. Use this function when your database doesn't support the record count.

 
You need to use this event together with ListFetchArray and ListQuery events. Read about it in the article How to display data returned by stored procedure.

Syntax

ListGetRowCount(searchObj,masterTable,masterKeysReq,selectedRecords,pageObject)

Arguments

searchObj

an instance of the class which performs search.

masterTable

a master table name.

masterKeysReq

an array of keys.

selectedRecords

an array of selected records on the Print page, null on the List page.

pageObject

an object representing the current page. For more information, see RunnerPage class.

Return value

The function returns the number of records or false.

Applies to pages

List, Print.

Examples

1. Return a hardcoded number of records:

 

doAssignmentByRef ListGetRowCount, 10

 

2. Calculate and return the number of records

 

doAssignmentByRef ListGetRowCount, DBLookup("select count(*) from test")

See also:

DAL method: DBLookup

About Database API

Connecting to the database

How to display data returned by stored procedure

List query

About Search API