Navigation:  Classes > bBrowser >

bBrowser:RowCountMode

Print this Topic    Previous pageReturn to chapter overviewNext page

Purpose

Mode in which the maximum number of data rows in the browser is calculated.

Class

bBrowser

Type

Access / Assign

Data Type

Symbol

Description

Dependent on this mode the method bBrowser:GetRowCount() calculates the number of data rows in different way.

 

The following modes are supported:

 

Mode

Description

#LastRec

The number of rows is determined by Server:LastRec.

#LastRow

The number of rows is determined by Server:LastRow.

#RecCount

The number of rows is determined by Server:RecCount.

#KeyCount

If in the server an index is active, the number of rows is determined by Server:OrderKeyCount() otherwise by Server:RecCount.

#Count

The number of rows is determined by Server:Count().

 

Note:
The method Count() must be defined in the data server class, otherwise a run-time error occurs. For example the method Count() is defined in the class DBServer but not in the class SQLSelect.

#Auto

If in the server no index is active, the number of rows is determined by Server:RecCount. If in the server an index without FOR condition is active, the number of rows is determined by Server:RecCount otherwise by Server:OrderKeyCount().

 

 

The mode #KeyCount should be used only with databases which contained the little than 10,000 records. With larger databases the calculation of the number of data rows is otherwise very time intensive.

 

If the mode is changed afterwards the method bBrowser:Refresh() must be called.

 

Important note!
The exact number of records, starting from which the method Server:OrderKeyCount() becomes slow depends on the computer performance and the database format (DBFNTX, DBFCDX). The indication of 10,000 records serves only as clue.
 
The bBrowser:RowCountMode should be set, before the data server is linked by the method bBrowser:Use() with the bBrowser.

See Also

bBrowser:GetRowCount()

bBrowser:RowMode

bBrowser:ServerType

 


Page url: http://www.YOURSERVER.com/index.html?bbrowser_rowcountmode.htm