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
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:
•How to display data returned by stored procedure