ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / WLanguage functions / Controls, pages and windows / Table functions
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
The following constants are used to manipulate Table, TreeView Table, Looper and List Box controls:
ConstantDescriptionUsed by the functions
amDisplayDestinationLine movement: The modified line is displayed in the field. If necessary, the lines are dequeued automatically to display the modified line in the Table control. The selected row (selection bar) does not change.
This constant can be combined with the amMove and amSwap constants.
TableMoveLine
ListMoveLine
LooperMoveLine
amFirstMove line: Moves the line to the first position.TableMoveLine
ListMoveLine
LooperMoveLine
amLastMove line: Moves the line to the last position.TableMoveLine
ListMoveLine
LooperMoveLine
amMoveMove line: The line is moved to the index of the destination line.TableMoveLine
ListMoveLine
LooperMoveLine
amNextMove line: Moves the line down one position.TableMoveLine
ListMoveLine
LooperMoveLine
amNextPageLine move: Moves the line down one page (one page corresponds to the number of lines that can be displayed simultaneously in the Table, List or RepeatString field).TableMoveLine
ListMoveLine
LooperMoveLine
amPreviousMove line: Moves the line up one position.TableMoveLine
ListMoveLine
LooperMoveLine
amPreviousPageLine move: Moves the line of a page upwards (a page corresponds to the number of lines that can be displayed simultaneously in the Table, List or RepeatString field).TableMoveLine
ListMoveLine
LooperMoveLine
amSwapLine shift: source and destination lines are exchanged.TableMoveLine
ListMoveLine
LooperMoveLine
filterContainsDisplays the rows whose value for the specified column "Contains" the specified characters.TableEnableFilter,
TableInputSearch,
MagnifierMode property
AssistedInputConfigure
filterDifferentDisplays the rows whose value for the specified column "differs" from the specified characters.TableEnableFilter,
TableInputSearch,
MagnifierMode property
AssistedInputConfigure
filterDoesNotContainDisplays the rows whose value for the specified column "does not contain" the specified characters.TableEnableFilter,
TableInputSearch,
MagnifierMode property
AssistedInputConfigure
filterDoesNotEndWithDisplays the rows whose value for the specified column "does not end with" the specified characters.TableEnableFilter,
TableInputSearch,
MagnifierMode property
AssistedInputConfigure
filterDoesNotStartWithDisplays the rows whose value for the specified column "Does not start with" the specified characters.TableEnableFilter,
TableInputSearch,
MagnifierMode property
AssistedInputConfigure
filterEndsWithDisplays the rows whose value for the specified column "ends with" the specified characters.TableEnableFilter,
TableInputSearch,
MagnifierMode property
AssistedInputConfigure
filterEqualDisplays the rows whose value for the specified column "is equal" to the specified characters.TableEnableFilter,
TableInputSearch,
MagnifierMode property
AssistedInputConfigure
filterGreaterDisplays the rows whose value for the specified column "is greater than" the specified characters.TableEnableFilter,
TableInputSearch,
MagnifierMode property
AssistedInputConfigure
filterGreaterOrEqualDisplays the rows whose value for the specified column "is greater than or equal to" the specified characters.TableEnableFilter,
TableInputSearch,
MagnifierMode property
AssistedInputConfigure
filterLessDisplays the rows whose value for the specified column "is less" than the specified charactersTableEnableFilter,
TableInputSearch,
MagnifierMode property
AssistedInputConfigure
filterLessOrEqualDisplays the rows whose value for the specified column "is less than or equal to" the specified characters.TableEnableFilter,
TableInputSearch,
MagnifierMode property
AssistedInputConfigure
filterNoneDisables the automatic filter used on the autocomplete suggestion list. The filter must be applied manually.AssistedInputConfigure
filterStartsWithDisplays the rows whose value for the specified column "Starts with" the specified characters.TableEnableFilter,
TableInputSearch,
MagnifierMode property
AssistedInputConfigure
rowAverageUsed to handle the row corresponding to an automatic calculation (Mean type).Automatic calculations in the tables
rowCountUsed to handle the row corresponding to an automatic calculation (count type).Automatic calculations in the tables
rowMaximumUsed to handle the row corresponding to an automatic calculation (Maximum type).Automatic calculations in the tables
rowMinimumUsed to handle the row corresponding to an automatic calculation (Minimum type).Automatic calculations in the tables
rowSelectedUsed to handle the row that is currently selected.ListMoveLine
TableMoveLine
LooperMoveLine
searchContainsGeneric search whose type is "Contains" TableSearch, LooperSearch, LooperSearchEverywhere
searchDefault
  • Sorts the Table control according to the specified column and switches the column to search mode.
  • Exact-match search whose type is "Equals to".
searchExactMatchExact-match search (whose type is "Equals to") TableSearch, LooperSearch, LooperSearchEverywhere
searchStartsWith
  • Sorts the Table control according to the specified column, switches the column to search mode and fills the edit control of the column with the characters specified in <Initial Value>.
  • Generic search whose type is "Starts with"
taByLogicalOrderThe columns are created according to the logical order of items defined in the data model editor.
For the queries, the logical order and the physical order of items are identical.
BuildBrowsingTable
taCollapseNode status: Wrapped nodeTableItemStatus
taColumnDisplayedOrderExports the columns according to the order of columns currently displayed in the Table control (and not according to the order of columns defined in the editor).ConfigureAAF
TableToClipboard
TableToText
TableToWord
TableToExcel
TableToXML
taColumnsTitlesWord/Excel file settings: Insert column titles.ConfigureAAF
TableToClipboard
TableToText
TableToWord
TableToExcel
TableToXML
LooperToExcel
LooperToWord
LooperToXML
taCurrentFirstRefreshes the Table control (Looper control or List box control) from the current file record. The first row is selected. This row corresponds to the current record.TableDisplay
ListDisplay
LooperDisplay
taCurrentRecordRefreshes the Table control from the current record in the file:
  • Re-runs the linked query if necessary.
  • Takes into account the records added, modified or deleted by other computers.
  • Selects the current record. If the current record is deleted or if it does not correspond to the filter, selects the next record that is not deleted.
  • The scrollbar position is stored as long as the selection remains visible.
  • Runs the beginning of initialization and the end of initialization, then the selection process of selected row (even if it is not modified).
TableDisplay
TreeDisplay
taCurrentSelectionRefreshes the Table control (Looper control or List box control) from the current file record. The position of selection bar is not modified. The selected record corresponds to the current record.TableDisplay
ListDisplay
LooperDisplay
TreeDisplay
taErrorNode status: Node does not exist
Element type: element does not exist
TableItemStatus
TableTypeItem
taExpandNode status: Node unrolledTableItemStatus
taFillTableFills a Table control populated programmatically with the file content.BuildBrowsingTable
taFirst
  • Son to return: the first son element
  • Position in table: First element in the table.
taImageSizeOnlyImage memo columns display size only and never load images. BuildBrowsingTable
taInitRe-display the control by running the initialization code.TableDisplay
ListDisplay
LooperDisplay
TreeDisplay
taItemCaptionThe column titles correspond to the captions of items typed in the analysis.BuildBrowsingTable
taKeepBrowseKeyThe search key of a Table control based on a data file does not change.BuildBrowsingTable
taKeepColumnKeeps the existing columns.BuildBrowsingTable
taLeafElement type: the element is a sheet.TableTypeItem
taMergeExports the content of Table control and merges the cells with the existing XLS file. The formatting and the existing formulas are kept. The data is not merged. The existing data is not stored. Only the data of columns found as well in the existing XLS file is kept.TableToExcel
LooperToExcel
taMultiLineColumnBy default, text columns are created with the Multiline property set to True. BuildBrowsingTable
taNextThread to send: the next thread
Table control to display: the next page
RepeatString field to be displayed: next page
TableGiveChild
TableDisplay
LooperDisplay
taNoAdjustThe width of columns is not adjusted.BuildBrowsingTable
taNodeElement type: the element is a node.TableTypeItem
taNoMemoImageImage Memo items are not added to the Table control.BuildBrowsingTable
taNoMemoTextText Memo items are not added to the Table control.BuildBrowsingTable
taNoTitleWord/Excel file settings: do not copy column titles.ConfigureAAF
TableToClipboard
TableToText
TableToWord
TableToExcel
TableToXML
LooperToExcel
LooperToWord
LooperToXML
taNoTotalDoes not export the rows containing totals, mean or automatic count (these rows are exported by default).ConfigureAAF
TableToClipboard
TableToText
TableToXML
TableToWord
TableToExcel
taNoUpdEditCbIf the control is an editable Combo Box control, the edit control associated with the Combo Box is not modified according to the new content of the list.
If this constant is not used: by default, the Edit control is modified.
ListDisplay
taNoXSLThe style sheet (file ".XSL") is not created.TableToXML
LooperToXML
taPreviousTable field to be displayed: the previous page.
RepeatString field to be displayed: the previous page.
TableDisplay
LooperDisplay
taReExecuteQuery
  • Refreshes the Table control (Looper control or List Box control) and positions at the beginning of control.
  • The first row is selected. This row corresponds to the first record.
  • Re-runs the query linked to the Table control (Looper or List Box control). For more details, see Table controls and queries.
Warning Only the query linked to the Table control (RepeatString or List Box control) is executed. If specific options have been specified with HExecuteQuery (hModifyFile, for example), these options are ignored.
TableDisplay
ListDisplay
LooperDisplay
TreeDisplay
New in version 2025
taRefreshIndicatorDown
Determines whether or not a wait indicator is displayed when the table is refreshed from the bottom.TableAddInProgress, LooperAddInProgress
New in version 2025
taRefreshIndicatorUp
Determines whether or not a wait indicator is displayed when the table is refreshed from the top.TableAddInProgress, LooperAddInProgress
taSelectedLinesExports the selected rows (all the rows are exported by default).ConfigureAAF
TableToClipboard
TableToText
TableToExcel
TableToWord
TableToXML
LooperToExcel
LooperToWord
LooperToXML
taSingleLineColumnBy default, text columns are created with the Multiline property set to False. BuildBrowsingTable
taStartRedisplays the Table control (Looper control or List Box control) by positioning on the first record of linked file. The first record is selected.TableDisplay
ListDisplay
LooperDisplay
TreeDisplay
taVisibleposition of line in table: visible line.TablePosition
taWithAutoIDCreates a column for the automatic identifierBuildBrowsingTable
taWithAutoIDInput allowed in the column associated with the automatic identifier.BuildBrowsingTable
taWithBinaryAdds the binary items (link composite key for example) into the Table control.BuildBrowsingTable
taWithDetailsBindingA sub-table is automatically generated to display the records found in the data files linked to the selected row. BuildBrowsingTable
taWithInvisibleColumnsExports the invisible columns to the Word or Excel file.ConfigureAAF
TableToClipboard
TableToText
TableToWord
TableToExcel
TableToXML
taWithLayoutExports the color and font of Table control.TableToExcel
LooperToExcel
tcpCreationColumn order: order in which columns are created.TableColumnIndex
tcpDisplayColumn order: order in which columns are displayed during execution.TableColumnIndex
tcsColumnRetrieves the column number.TableCellSelect
tcsLineRetrieves the row number.TableCellSelect
tiColNameType of information to be returned: column name.TableInfoXY
tiColNumberType of information to be returned: column creation index.TableInfoXY
tiLineNumberType of information to be returned: line index.TableInfoXY
tiOnButtonCollapseExpandType of information to be returned: Coordinates correspond to the "+/-" buttons for unfolding/unfolding a line in a TreeView Table control.TableInfoXY
tiOriginScreenModifies the origin used.
By default, point (0,0) corresponds to row 1, column 1 (with scrollbars at origin). If tiOriginScreen is used, (0,0) corresponds to the origin of the screen.
TableInfoXY
tmInChildType of move: The branch is moved and will be the first child of the destination branch.. The branch moved will be positioned one level below the destination branch in the hierarchy.TableMoveBranch
tmInSiblingType of move: The branch will be moved and will be the next sibling of the destination branch.. The branch moved will be positioned on the same hierarchy level as the destination branch but at the following position.TableMoveBranch
toColumnElement taken into account: number of columns in Table control, number of attributes in RepeatString control.TableCount
LooperCount
toShownElement taken into account:
  • number of non-empty rows visible in the Table control,
  • number of non-empty rows visible in the Looper control,
  • number of widgets visible in a Dashboard control.
TableCount
LooperCount
DashCount
toTotal
  • Table control based on a data file:
    • Total number of records in the linked file (filtered or not)
    • Number of visible records (Table control with continuous scrollbar)
  • Table populated programmatically field number of lines in memory
  • RepeatString field: total number of recordings
  • RepeatString field by programming: number of repeats in memory
  • Dashboard control field: total number of Widgets
TableCount
LooperCount
DashCount
toVisibleElements taken into account: maximum number of visible rows in the Table control, maximum number of visible repeats in the RepeatString control.TableCount
LooperCount
tsCellElement taken into account: Number of cells selected.TableSelectCount
tsCellColumnElement taken into account: Column number for the cell selected in the Table control.TableSelect
tsCellRowElement taken into account: Line number for the cell selected in the Table control.
TableSelect
tsColumnElement taken into account:
  • Number of the selected column.
  • Number of selected columns.
TableSelect
TableSelectCount
New in SaaS
tsLineWithoutFilter
Element taken into account: Line number for the selected line, regardless of filter (if any).TableSelect
tsRowElement taken into account:
  • Number of the selected row.
  • Number of selected rows.
TableSelect
TableSelectCount
WithAllTable control print settings: Print the table taking all options into account (corresponds to WithMultipagesColumn + WithDate + WithNbRecords + WithNbPages + WithTitle)TablePrint
WithDateTable control print settings: the date is printed at the top of the page.TablePrint
WithMultipageColumnsTable control print settings: if the contents of the Table control do not fit on one page, the columns are printed on several pages.TablePrint
WithNbPagesTable control print settings: the number of pages is printed at the bottom of the page.TablePrint
WithNbRecordsTable control print settings: number of records printed at end of document. The caption used corresponds to the caption defined for the counter (in the Table control description).TablePrint
WithTitleTable control print settings: page title printed at top of page. If the title of Table control is not visible, prints the window title.TablePrint
The following constants are used to manipulate Table, TreeView Table, Looper and List Box controls in prefix syntax:
ConstantDescriptionUsed by the functions
amDisplayDestinationLine movement: The modified line is displayed in the field. If necessary, the lines are dequeued automatically to display the modified line in the Table control. The selected row (selection bar) does not change.
This constant can be combined with the amMove and amSwap constants.
<Table>.MoveLine
<List box>.MoveLine
<Looper>.MoveLine
amFirstMove line: Moves the line to the first position.<Table>.MoveLine
<List box>.MoveLine
<Looper>.MoveLine
amLastMove line: Moves the line to the last position.<Table>.MoveLine
<List box>.MoveLine
<Looper>.MoveLine
amMoveMove line: The line is moved to the index of the destination line.<Table>.MoveLine
<List box>.MoveLine
<Looper>.MoveLine
amNextMove line: Moves the line down one position.<Table>.MoveLine
<List box>.MoveLine
<Looper>.MoveLine
amNextPageLine move: Moves the line down one page (one page corresponds to the number of lines that can be displayed simultaneously in the Table, List or RepeatString field).<Table>.MoveLine
<List box>.MoveLine
<Looper>.MoveLine
amPreviousMove line: Moves the line up one position.<Table>.MoveLine
<List box>.MoveLine
<Looper>.MoveLine
amPreviousPageLine move: Moves the line of a page upwards (a page corresponds to the number of lines that can be displayed simultaneously in the Table, List or RepeatString field).<Table>.MoveLine
<List box>.MoveLine
<Looper>.MoveLine
amSwapLine shift: source and destination lines are exchanged.<Table>.MoveLine
<List box>.MoveLine
<Looper>.MoveLine
filterContainsDisplays the rows whose value for the specified column "Contains" the specified characters.TableEnableFilter,
<Table column>.InputSearch,
MagnifierMode property
<Edit>.ConfigureAssistedInput
filterDifferentDisplays the rows whose value for the specified column "differs" from the specified characters.TableEnableFilter,
<Table column>.InputSearch,
MagnifierMode property
<Edit>.ConfigureAssistedInput
filterDoesNotContainDisplays the rows whose value for the specified column "does not contain" the specified characters.TableEnableFilter,
<Table column>.InputSearch,
MagnifierMode property
<Edit>.ConfigureAssistedInput
filterDoesNotEndWithDisplays the rows whose value for the specified column "does not end with" the specified characters.TableEnableFilter,
<Table column>.InputSearch,
MagnifierMode property
<Edit>.ConfigureAssistedInput
filterDoesNotStartWithDisplays the rows whose value for the specified column "Does not start with" the specified characters.TableEnableFilter,
<Table column>.InputSearch,
MagnifierMode property
<Edit>.ConfigureAssistedInput
filterEndsWithDisplays the rows whose value for the specified column "ends with" the specified characters.TableEnableFilter,
<Table column>.InputSearch,
MagnifierMode property
<Edit>.ConfigureAssistedInput
filterEqualDisplays the rows whose value for the specified column "is equal" to the specified characters.TableEnableFilter,
<Table column>.InputSearch,
MagnifierMode property
<Edit>.ConfigureAssistedInput
filterGreaterDisplays the rows whose value for the specified column "is greater than" the specified characters.TableEnableFilter,
<Table column>.InputSearch,
MagnifierMode property
<Edit>.ConfigureAssistedInput
filterGreaterOrEqualDisplays the rows whose value for the specified column "is greater than or equal to" the specified characters.TableEnableFilter,
<Table column>.InputSearch,
MagnifierMode property
<Edit>.ConfigureAssistedInput
filterLessDisplays the rows whose value for the specified column "is less" than the specified charactersTableEnableFilter,
<Table column>.InputSearch,
MagnifierMode property
<Edit>.ConfigureAssistedInput
filterLessOrEqualDisplays the rows whose value for the specified column "is less than or equal to" the specified characters.TableEnableFilter,
<Table column>.InputSearch,
MagnifierMode property
<Edit>.ConfigureAssistedInput
filterNoneDisables the automatic filter used on the autocomplete suggestion list. The filter must be applied manually.<Edit>.ConfigureAssistedInput
filterStartsWithDisplays the rows whose value for the specified column "Starts with" the specified characters.TableEnableFilter,
<Table column>.InputSearch,
MagnifierMode property
<Edit>.ConfigureAssistedInput
rowAverageUsed to handle the row corresponding to an automatic calculation (Mean type).Automatic calculations in the tables
rowCountUsed to handle the row corresponding to an automatic calculation (count type).Automatic calculations in the tables
rowMaximumUsed to handle the row corresponding to an automatic calculation (Maximum type).Automatic calculations in the tables
rowMinimumUsed to handle the row corresponding to an automatic calculation (Minimum type).Automatic calculations in the tables
rowSelectedUsed to handle the row that is currently selected.<List box>.MoveLine
<Table>.MoveLine
<Looper>.MoveLine
searchContainsGeneric search whose type is "Contains" TableSearch,
<Looper>.SearchEverywhere
searchDefault
  • Sorts the Table control according to the specified column and switches the column to search mode.
  • Exact-match search whose type is "Equals to".
<Table column>.InputSearch,
MagnifierMode property,
TableSearch
searchExactMatchExact-match search (whose type is "Equals to") TableSearch,
<Looper>.SearchEverywhere
searchStartsWith
  • Sorts the Table control according to the specified column, switches the column to search mode and fills the edit control of the column with the characters specified in <Initial Value>.
  • Generic search whose type is "Starts with"
<Table column>.InputSearch,
MagnifierMode property,
TableSearch,
<Looper>.SearchEverywhere
taByLogicalOrderThe columns are created according to the logical order of items defined in the data model editor.
For the queries, the logical order and the physical order of items are identical.
BuildBrowsingTable
taCollapseNode status: Wrapped node<TreeView Table>.ItemStatus
taColumnDisplayedOrderExports the columns according to the order of columns currently displayed in the Table control (and not according to the order of columns defined in the editor).ConfigureAAF
TableToClipboard
TableToText
TableToWord
TableToExcel
TableToXML
taColumnsTitlesWord/Excel file settings: Insert column titles.ConfigureAAF
TableToClipboard
TableToText
TableToWord
TableToExcel
TableToXML
<Looper>.ToExcel
<Looper>.ToWord
<Looper>.ToXML
taCurrentFirstRefreshes the Table control (Looper control or List box control) from the current file record. The first row is selected. This row corresponds to the current record.<Table>.Display
<List box>.Display
<Looper>.Display
taCurrentRecordRefreshes the Table control from the current record in the file:
  • Re-runs the linked query if necessary.
  • Takes into account the records added, modified or deleted by other computers.
  • Selects the current record. If the current record is deleted or if it does not correspond to the filter, selects the next record that is not deleted.
  • The scrollbar position is stored as long as the selection remains visible.
  • Runs the beginning of initialization and the end of initialization, then the selection process of selected row (even if it is not modified).
<Table>.Display
<TreeView>.Display
taCurrentSelectionRefreshes the Table control (Looper control or List box control) from the current file record. The position of selection bar is not modified. The selected record corresponds to the current record.<Table>.Display
<List box>.Display
<Looper>.Display
<TreeView>.Display
taErrorNode status: Node does not exist
Element type: element does not exist
<TreeView Table>.ItemStatus
<TreeView Table>.TypeItem
taExpandNode status: Node unrolled<TreeView Table>.ItemStatus
taFillTableFills a Table control populated programmatically with the file content.BuildBrowsingTable
taFirst
  • Son to return: the first son element
  • Position in table: First element in the table.
<TreeView Table>.GiveChild,
<Table>.Position
taInitRe-display the control by running the initialization code.<Table>.Display
<List box>.Display
<Looper>.Display
<TreeView>.Display
taItemCaptionThe column titles correspond to the captions of items typed in the analysis.BuildBrowsingTable
taKeepBrowseKeyThe search key of a Table control based on a data file does not change.BuildBrowsingTable
taKeepColumnKeeps the existing columns.BuildBrowsingTable
taLeafElement type: the element is a sheet.<TreeView Table>.TypeItem
taMergeExports the content of Table control and merges the cells with the existing XLS file. The formatting and the existing formulas are kept. The data is not merged. The existing data is not stored. Only the data of columns found as well in the existing XLS file is kept.TableToExcel
<Looper>.ToExcel
taMultiLineColumnBy default, text columns are created with the Multiline property set to True. BuildBrowsingTable
taNextThread to send: the next thread
Table control to display: the next page
RepeatString field to be displayed: next page
<TreeView Table>.GiveChild
<Table>.Display
<Looper>.Display
taNoAdjustThe width of columns is not adjusted.BuildBrowsingTable
taNodeElement type: the element is a node.<TreeView Table>.TypeItem
taNoMemoImageImage Memo items are not added to the Table control.BuildBrowsingTable
taNoMemoTextText Memo items are not added to the Table control.BuildBrowsingTable
taNoTitleWord/Excel file settings: do not copy column titles.ConfigureAAF
TableToClipboard
TableToText
TableToWord
TableToExcel
TableToXML
<Looper>.ToExcel
<Looper>.ToWord
<Looper>.ToXML
taNoTotalDoes not export the rows containing totals, mean or automatic count (these rows are exported by default).ConfigureAAF
TableToClipboard
TableToText
TableToXML
TableToWord
TableToExcel
taNoUpdEditCbIf the control is an editable Combo Box control, the edit control associated with the Combo Box is not modified according to the new content of the list.
If this constant is not used: by default, the Edit control is modified.
<List box>.Display
taNoXSLThe style sheet (file ".XSL") is not created.TableToXML
<Looper>.ToXML
taPreviousTable field to be displayed: the previous page.
RepeatString field to be displayed: the previous page.
<Table>.Display
<Looper>.Display
taReExecuteQuery
  • Refreshes the Table control (Looper control or List Box control) and positions at the beginning of control.
  • The first row is selected. This row corresponds to the first record.
  • Re-runs the query linked to the Table control (Looper or List Box control). For more details, see Table controls and queries.
Warning Only the query linked to the Table control (RepeatString or List Box control) is executed. If specific options have been specified with HExecuteQuery (hModifyFile, for example), these options are ignored.
<Table>.Display
<List box>.Display
<Looper>.Display
<TreeView>.Display
New in version 2025
taRefreshIndicatorDown
Determines whether or not a wait indicator is displayed when the table is refreshed from the bottom.<Table>.AddInProgress, <Looper>.AddInProgress
New in version 2025
taRefreshIndicatorUp
Determines whether or not a wait indicator is displayed when the table is refreshed from the top.<Table>.AddInProgress, <Looper>.AddInProgress
taSelectedLinesExports the selected rows (all the rows are exported by default).ConfigureAAF
TableToClipboard
TableToText
TableToExcel
TableToWord
TableToXML
<Looper>.ToExcel
<Looper>.ToWord
<Looper>.ToXML
taSingleLineColumnBy default, text columns are created with the Multiline property set to False. BuildBrowsingTable
taStartRedisplays the Table control (Looper control or List Box control) by positioning on the first record of linked file. The first record is selected.<Table>.Display
<List box>.Display
<Looper>.Display
<TreeView>.Display
taVisibleposition of line in table: visible line.<Table>.Position
taWithAutoIDCreates a column for the automatic identifierBuildBrowsingTable
taWithAutoIDInput allowed in the column associated with the automatic identifier.BuildBrowsingTable
taWithBinaryAdds the binary items (link composite key for example) into the Table control.BuildBrowsingTable
taWithDetailsBindingA sub-table is automatically generated to display the records found in the data files linked to the selected row. BuildBrowsingTable
taWithInvisibleColumnsExports the invisible columns to the Word or Excel file.ConfigureAAF
TableToClipboard
TableToText
TableToWord
TableToExcel
TableToXML
taWithLayoutExports the color and font of Table control.TableToExcel
<Looper>.ToExcel
tcpCreationColumn order: order in which columns are created.<Table>.ColumnIndex
tcpDisplayColumn order: order in which columns are displayed during execution.<Table>.ColumnIndex
tcsColumnRetrieves the column number.<Table>.CellSelect
tcsLineRetrieves the row number.<Table>.CellSelect
tiColNameType of information to be returned: column name.<Table>.InfoXY
tiColNumberType of information to be returned: column creation index.<Table>.InfoXY
tiLineNumberType of information to be returned: line index.<Table>.InfoXY
tiOnButtonCollapseExpandType of information to be returned: Coordinates correspond to the "+/-" buttons for unfolding/unfolding a line in a TreeView Table control.<Table>.InfoXY
tiOriginScreenModifies the origin used.
By default, point (0,0) corresponds to row 1, column 1 (with scrollbars at origin). If tiOriginScreen is used, (0,0) corresponds to the origin of the screen.
<Table>.InfoXY
tmInChildType of move: The branch is moved and will be the first child of the destination branch.. The branch moved will be positioned one level below the destination branch in the hierarchy.<TreeView Table>.MoveBranch
tmInSiblingType of move: The branch will be moved and will be the next sibling of the destination branch.. The branch moved will be positioned on the same hierarchy level as the destination branch but at the following position.<TreeView Table>.MoveBranch
toColumnElement taken into account: number of columns in Table control, number of attributes in RepeatString control.<Table>.Count
<Looper>.Count
toShownElement taken into account:
  • number of non-empty rows visible in the Table control,
  • number of non-empty rows visible in the Looper control,
  • number of widgets visible in a Dashboard control.
<Table>.Count
<Looper>.Count
DashCount
toTotal
  • Table control based on a data file:
    • Total number of records in the linked file (filtered or not)
    • Number of visible records (Table control with continuous scrollbar)
  • Table populated programmatically field number of lines in memory
  • RepeatString field: total number of recordings
  • RepeatString field by programming: number of repeats in memory
  • Dashboard control field: total number of Widgets
<Table>.Count
<Looper>.Count
DashCount
toVisibleElements taken into account: maximum number of visible rows in the Table control, maximum number of visible repeats in the RepeatString control.<Table>.Count
<Looper>.Count
tsCellElement taken into account: Number of cells selected.<Table>.SelectCount
tsCellColumnElement taken into account: Column number for the cell selected in the Table control.<Table>.Select
tsCellRowElement taken into account: Line number for the cell selected in the Table control.
<Table>.Select
tsColumnElement taken into account:
  • Number of the selected column.
  • Number of selected columns.
<Table>.Select
<Table>.SelectCount
New in SaaS
tsLineWithoutFilter
Element taken into account: Line number for the selected line, regardless of filter (if any).<Table>.Select
tsRowElement taken into account:
  • Number of the selected row.
  • Number of selected rows.
<Table>.Select
<Table>.SelectCount
WithAllTable control print settings: Print the table taking all options into account (corresponds to WithMultipagesColumn + WithDate + WithNbRecords + WithNbPages + WithTitle)<Table>.Print
WithDateTable control print settings: the date is printed at the top of the page.<Table>.Print
WithMultipageColumnsTable control print settings: if the contents of the Table control do not fit on one page, the columns are printed on several pages.<Table>.Print
WithNbPagesTable control print settings: the number of pages is printed at the bottom of the page.<Table>.Print
WithNbRecordsTable control print settings: number of records printed at end of document. The caption used corresponds to the caption defined for the counter (in the Table control description).<Table>.Print
WithTitleTable control print settings: page title printed at top of page. If the title of Table control is not visible, prints the window title.<Table>.Print
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/20/2025

Send a report | Local help