|
|
|
|
|
|
|
|
|
|
<Table>.Count (Function) In french: <Table>.Occurrence Returns: - the number of columns found in a Table or TreeView Table control.
- or the number of lines in a Table or hierarchical Table control.
ResNombreLigne = TABLE_Produit.Occurrence()
Syntax
<Result> = <Table control>.Count([<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.
<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 lines (thanks to the Visible property) are still 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)Warning The end-of-initialization code is only executed once the total has been calculated.
| Number of rows in memory (rows added by the user or rows added by <Table>.Add, <Table>.AddLine, <Table>.Insert and <Table>.InsertLine). 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 lines (thanks to the Visible property) are still counted. |
Remarks Use conditions <Table>.Count 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…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|