Navigation:  Classes > bBrowser >

bBrowser:RowMode

Print this Topic    Previous pageReturn to chapter overviewNext page

Purpose

Mode in which the first visible data row in the browser is calculated.

Class

bBrowser

Type

Access / Assign

Data Type

Symbol

Description

If in the linked server an index is active, the bBrowser determines the first visible data row by the access Server:OrderKeyNo. With databases with more than 10000 records this access becomes however slower, the further the bBrowser approaches to the end of file.

 

In order to solve this problem, offers to the bBrowser possibility of determining the first visible data row by the access Server:RecNo. This access effected very fast and does not depend on the number of records in the database. This proceeding has however the disadvantage that the slider in the vertical scrollbar cannot indicate no more the relative position in the server, because the calculation of this position is likewise made by the access Server:OrderKeyNo. The slider is always in the center of the vertical scrollbar. Only with the first or last record the slider is moved to the top or bottom of the scrollbar.

 

The following table lists the modes that can be used for the calculation of the first visible data row:

 

Mode

Description

#Relative

If in the linked server an index is active, the first visible row is determined by the access Server:OrderKeyNo otherwise by the access Server:RecNo.

 

This mode is the default.

 

Important note!
With databases with more than 10000 records that is very slow access to Server:OrdeKeyNo.

#Absolute

The first visible row is calculated by the access Server:RecNo.

 

Important note!
With this mode the slider in the vertical scrollbar does not show the relative position inside the server.

 

If the mode is changed, the bBrowser:RowCountMode is changed also automatically as follows:

 

RowMode

RowCountMode

#Relative

#Auto

#Absolute

#RecCount

 

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

 

After creating a bBrowser control the mode #Relative is active.

 

Important note!
The exact number of records, starting from which the access Server:OrderKeyNo becomes slow depends on the computer performance and the database format (DBFNTX, DBFCDX). The indication of 10000 records serves only as clue.
 
The bBrowser:RowMode should be set, before the data server is linked by the method bBrowser:Use() with the bBrowser.
 
With the combination bBrowser:SelectionMode #Multiple and bBrowser:RowMode #Absolute no block selection for cells/rows is supported. Several single cells/rows can be selected however (see also bBrowser:PropertyPut(#RMASelectionMode)).

See Also

bBrowser:RowCountMode

bBrowser:SelectionMode

 


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