|
|
|
|
|
TableCount (Function) In french: TableOccurrence Returns: - the number of columns found in a Table or TreeView Table control.
- the number of rows found in a Table or TreeView Table control.
// Number of rows found in the "TABLE_Product" control ResNumberRow = TableCount(TABLE_Product) Syntax
<Result> = TableCount(<Table control> [, <Row/Column>])
<Result>: Integer Number of rows or columns found in the specified control. <Table control>: Control name Name of the control to be used. This control can correspond to: - a Table control.
- a TreeView Table control.
If this parameter corresponds to an empty string (""), the control to which the current event belongs will be used. <Row/Column>: Integer constant (optional) Used to specify the type of returned result: - the toShown, toTotal and toVisible constants contain a number of rows.
- the toColumn constant contains the number of columns in the control.
| | | | Table or TreeView Table control based on a data file | Table or TreeView Table control populated programmatically |
---|
toShown
| Number of non-empty rows visible in the control.
| Number of non-empty rows in the visible part of the control.Remark: Hidden rows (with the Visible property ) are counted. | toColumn | Number of columns found in the control. | Number of columns found in the control. | toTotal (Default value)
| - Total number of records ("Proportional scrollbar" is checked):
- of the linked file (if there is no filter).
- filtered of the linked file (if there is a filter).
- in the query (if the control is linked to a query).
- Number of visible records if the control includes a scrollbar with an ongoing movement ("Proportional scrollbar" unchecked)Caution: The "end of initialization" code is run when the total is calculated.
| Number of rows in memory (rows added by the user or rows added by TableAdd, TableAddLine, TableInsert and TableInsertLine). Remarks: - Hidden rows (with the Visible property ) are counted.
- Rows filtered with TableEnableFilter or filtered by the user are not counted.
| toVisible
| Number of visible rows (including the empty rows or the rows that are partially displayed). Corresponds to the maximum number of rows that can be displayed in the control.
| Number of visible rows (including the empty rows or the rows that are partially displayed). Corresponds to the maximum number of rows that can be displayed in the control.Remark: Hidden rows (with the Visible property ) are counted. |
Remarks Use conditions TableCount can be used on: - Table or TreeView Table controls based on a data file.
- Table or TreeView Table controls populated programmatically.
- single-selection or multi-selection controls.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|