PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Versions 19 and later
WEBDEV - Browser code Most of these constants are now available in browser code.
New in version 19
WEBDEV - Browser code Most of these constants are now available in browser code.
WEBDEV - Browser code Most of these constants are now available in browser code.
The following constants are used to manage the Table, TreeView Table, Looper and List Box controls:
ConstantAffectsUsed by the functions
amDisplayDestinationRow movement: The modified row is displayed in the control. If necessary, the rows are automatically scrolled to display the modified row in the Table control. The selected row (selection bar) is not modified.
This constant can be combined with the amMove and amSwap constants.
TableMoveLine
ListMoveLine
LooperMoveLine
amFirstRow movement: Moves the row to first position.TableMoveLine
ListMoveLine
LooperMoveLine
amLastRow movement: Moves the row to last position.TableMoveLine
ListMoveLine
LooperMoveLine
amMoveRow movement: The row is moved toward the subscript of destination row.TableMoveLine
ListMoveLine
LooperMoveLine
amNextRow movement: Moves the row one position to the bottom.TableMoveLine
ListMoveLine
LooperMoveLine
amNextPageRow movement: Moves the row one page to the bottom (a page corresponds to the number of rows that can be simultaneously displayed in the Table, List Box or Looper control).TableMoveLine
ListMoveLine
LooperMoveLine
amPreviousRow movement: Moves the row one position to the top.TableMoveLine
ListMoveLine
LooperMoveLine
amPreviousPageRow movement: Moves the row one page to the top (a page corresponds to the number of rows that can be simultaneously displayed in the Table, List Box or Looper control).TableMoveLine
ListMoveLine
LooperMoveLine
amSwapRow movement: The source row and the destination row are swapped.TableMoveLine
ListMoveLine
LooperMoveLine
filterContainsDisplays the rows whose value for the specified column "Contains" the specified characters.TableEnableFilter,
TableInputSearch,
..MagnifierMode
Versions 19 and later
AssistedInputConfigure
New in version 19
AssistedInputConfigure
AssistedInputConfigure
filterDifferentDisplays the rows whose value for the specified column "differs" from the specified characters.TableEnableFilter,
TableInputSearch,
..MagnifierMode
Versions 19 and later
AssistedInputConfigure
New in version 19
AssistedInputConfigure
AssistedInputConfigure
filterDoesNotContainDisplays the rows whose value for the specified column "does not contain" the specified characters.TableEnableFilter,
TableInputSearch,
..MagnifierMode
Versions 19 and later
AssistedInputConfigure
New in version 19
AssistedInputConfigure
AssistedInputConfigure
filterDoesNotEndWithDisplays the rows whose value for the specified column "does not end with" the specified characters.TableEnableFilter,
TableInputSearch,
..MagnifierMode
Versions 19 and later
AssistedInputConfigure
New in version 19
AssistedInputConfigure
AssistedInputConfigure
filterDoesNotStartWithDisplays the rows whose value for the specified column "Does not start with" the specified characters.TableEnableFilter,
TableInputSearch,
..MagnifierMode
Versions 19 and later
AssistedInputConfigure
New in version 19
AssistedInputConfigure
AssistedInputConfigure
filterEndsWithDisplays the rows whose value for the specified column "ends with" the specified characters.TableEnableFilter,
TableInputSearch,
..MagnifierMode
Versions 19 and later
AssistedInputConfigure
New in version 19
AssistedInputConfigure
AssistedInputConfigure
filterEqualDisplays the rows whose value for the specified column "is equal" to the specified characters.TableEnableFilter,
TableInputSearch,
..MagnifierMode
Versions 19 and later
AssistedInputConfigure
New in version 19
AssistedInputConfigure
AssistedInputConfigure
filterGreaterDisplays the rows whose value for the specified column "is greater than" the specified characters.TableEnableFilter,
TableInputSearch,
..MagnifierMode
Versions 19 and later
AssistedInputConfigure
New in version 19
AssistedInputConfigure
AssistedInputConfigure
filterGreaterOrEqualDisplays the rows whose value for the specified column "is greater than or equal to" the specified characters.TableEnableFilter,
TableInputSearch,
..MagnifierMode
Versions 19 and later
AssistedInputConfigure
New in version 19
AssistedInputConfigure
AssistedInputConfigure
filterLessDisplays the rows whose value for the specified column "is less" than the specified charactersTableEnableFilter,
TableInputSearch,
..MagnifierMode
Versions 19 and later
AssistedInputConfigure
New in version 19
AssistedInputConfigure
AssistedInputConfigure
filterLessOrEqualDisplays the rows whose value for the specified column "is less than or equal to" the specified characters.TableEnableFilter,
TableInputSearch,
..MagnifierMode
Versions 19 and later
AssistedInputConfigure
New in version 19
AssistedInputConfigure
AssistedInputConfigure
Versions 19 and later
filterNone
New in version 19
filterNone
filterNone
Disables the automatic filter used by the assisted input. The filter must be performed manually.
Versions 19 and later
AssistedInputConfigure
New in version 19
AssistedInputConfigure
AssistedInputConfigure
filterStartsWithDisplays the rows whose value for the specified column "Starts with" the specified characters.TableEnableFilter,
TableInputSearch,
..MagnifierMode
Versions 19 and later
AssistedInputConfigure
New in version 19
AssistedInputConfigure
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
Versions 22 and later
rowMaximum
New in version 22
rowMaximum
rowMaximum
Used to handle the row corresponding to an automatic calculation (Maximum type).Automatic calculations in the tables
Versions 22 and later
rowMinimum
New in version 22
rowMinimum
rowMinimum
Used 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
Versions 21 and later
searchContains
New in version 21
searchContains
searchContains
Generic search whose type is "Contains" TableSeek, LooperSeek,
Versions 21 and later
LooperSeekAnywhere
New in version 21
LooperSeekAnywhere
LooperSeekAnywhere
searchDefault
  • Sorts the Table control according to the specified column and switches the column to search mode.
  • Versions 21 and later
    Exact-match search whose type is "Equals to".
    New in version 21
    Exact-match search whose type is "Equals to".
    Exact-match search whose type is "Equals to".
Versions 21 and later
searchExactMatch
New in version 21
searchExactMatch
searchExactMatch
Exact-match search (whose type is "Equals to") TableSeek, LooperSeek,
Versions 21 and later
LooperSeekAnywhere
New in version 21
LooperSeekAnywhere
LooperSeekAnywhere
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>.
  • Versions 21 and later
    Generic search whose type is "Starts with"
    New in version 21
    Generic search whose type is "Starts with"
    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: The node is collapsedTableItemStatus
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
taColumnsTitlesConfigure the Word/Excel file: inserts the title of columns.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
Versions 16 and later
TreeDisplay
New in version 16
TreeDisplay
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
Versions 16 and later
TreeDisplay
New in version 16
TreeDisplay
TreeDisplay
taErrorNode status: Node not found
Type of element: the element does not exist
TableItemStatus
TableTypeItem
taExpandNode status: The node is expandedTableItemStatus
taFillTableFills a memory Table control with the file content.BuildBrowsingTable
taFirst
  • Child to return: the first child element
  • Versions 22 and later
    Position in the table: First table element
    New in version 22
    Position in the table: First table element
    Position in the table: First table element
taInitRe-display the control by running the initialization code.TableDisplay
ListDisplay
LooperDisplay
Versions 16 and later
TreeDisplay
New in version 16
TreeDisplay
TreeDisplay
taInputAutoIdInput allowed in the column associated with the automatic identifier.BuildBrowsingTable
taItemCaptionThe titles of columns correspond to the captions of items typed in the analysis.BuildBrowsingTable
taKeepBrowseKeySearch key of BrowsingTable control not modified.BuildBrowsingTable
taKeepColumnKeeps the existing columns.BuildBrowsingTable
taLeafType of element: the element is a leaf.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
taNextChild to return: the next child
Table control to display: the next page
Looper control to display: the next page
TableGiveChild
TableDisplay
LooperDisplay
taNoAdjustThe width of columns is not adjusted.BuildBrowsingTable
taNodeType of element: the element is a node.TableTypeItem
taNoMemoImageThe Image Memo items are not added into the Table control.BuildBrowsingTable
taNoMemoTextThe Text Memo items are not added into the Table control.BuildBrowsingTable
taNoTitleConfigure the Word/Excel file: does not copy the title of columns.ConfigureAAF
TableToClipboard
TableToText
TableToWord
TableToExcel
TableToXML
LooperToExcel
LooperToWord
LooperToXML
taNoTotalDoes not export rows with totals, average or automatic count (these rows are exported by default).ConfigureAAF
TableToClipboard
TableToText
TableToXML
TableToWord
TableToExcel
Versions 15 and later
taNoUpdEditCb
New in version 15
taNoUpdEditCb
taNoUpdEditCb
If 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: the edit control of the combo box is modified by default.
ListDisplay
taNoXSLThe style sheet (".XSL" file) is not created.TableToXML
LooperToXML
taPreviousTable control to display: the previous page.
Looper control to display: 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). See Table controls and queries for more details.
Caution: Only the query linked to the Table control (Looper or List Box) will be run. If specific options have been specified by HExecuteQuery (hModifyFile for example), these options are ignored.
TableDisplay
ListDisplay
LooperDisplay
Versions 16 and later
TreeDisplay
New in version 16
TreeDisplay
TreeDisplay
taSelectedLinesExports the selected rows (all the rows are exported by default).ConfigureAAF
TableToClipboard
TableToText
TableToExcel
TableToWord
TableToXML
LooperToExcel
LooperToWord
LooperToXML
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
Versions 16 and later
TreeDisplay
New in version 16
TreeDisplay
TreeDisplay
Versions 22 and later
taVisible
New in version 22
taVisible
taVisible
position of the row in the table: visible row.TablePosition
taWithAutoIdCreates a column for the automatic identifierBuildBrowsingTable
taWithBinaryAdds the binary items (link composite key for example) into the Table control.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
Versions 23 and later
taWithLinkDetails
New in version 23
taWithLinkDetails
taWithLinkDetails
A sub-table is automatically generated to display the records found in the data files linked to the selected row. BuildBrowsingTable
tcpCreationOrder of columns: order in which the columns are created.TableColumnSubscript
tcpDisplayOrder of columns: order in which the columns are displayed at run time.TableColumnSubscript
Versions 16 and later
tcsColumn
New in version 16
tcsColumn
tcsColumn
Retrieves the column number.TableCellSelect
Versions 16 and later
tcsLine
New in version 16
tcsLine
tcsLine
Retrieves the row number.TableCellSelect
tiColNameType of information to return: name of column.TableInfoXY
tiColNumberType of information to return: creation subscript of column.TableInfoXY
tiLineNumberType of information to return: row subscript.TableInfoXY
tiOriginScreenModifies the origin used.
By default, (0,0) corresponds to row 1, column 1 (the scrollbars being located at the origin). If tiOriginScreen is used, (0,0) corresponds to the origin of the screen.
TableInfoXY
Versions 18 and later
tmInChild
New in version 18
tmInChild
tmInChild
Type of move: The branch is moved and it will be the first child of destination branch. The branch moved will be positioned one level below the destination branch in the hierarchy.
Versions 18 and later
TableMoveBranch
New in version 18
TableMoveBranch
TableMoveBranch
Versions 18 and later
tmInSibling
New in version 18
tmInSibling
tmInSibling
Type of move: The branch is moved and it 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.
Versions 18 and later
TableMoveBranch
New in version 18
TableMoveBranch
TableMoveBranch
toColumnElement taken into account: number of columns in the Table control, number of attributes in the Looper 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,
  • Versions 19 and later
    number of Widgets visible in a Dashboard control.
    New in version 19
    number of Widgets visible in a Dashboard control.
    number of Widgets visible in a Dashboard control.
TableCount
LooperCount
Versions 19 and later
DashCount
New in version 19
DashCount
DashCount
toTotal
  • Browsing Table control:
    • Total number of records in the linked file (filtered or not)
    • Number of visible records (Table control with continuous scrollbar)
  • Memory Table control: number of rows in memory
  • Browsing Looper control: total number of records
  • Memory Looper control: number of rows in memory
  • Versions 19 and later
    Dashboard control: total number of Widgets
    New in version 19
    Dashboard control: total number of Widgets
    Dashboard control: total number of Widgets
TableCount
LooperCount
Versions 19 and later
DashCount
New in version 19
DashCount
DashCount
toVisibleElements taken into account: maximum number of rows visible in the Table control or in the Looper control.TableCount
LooperCount
Versions 16 and later
tsCell
New in version 16
tsCell
tsCell
Element taken into account: Number of selected cells.TableSelectCount
Versions 16 and later
tsCellColumn
New in version 16
tsCellColumn
tsCellColumn
Element taken into account: Number of the column for the cell selected in the Table control.TableSelect
Versions 16 and later
tsCellLine
New in version 16
tsCellLine
tsCellLine
Element taken into account: Number of the row for the cell selected in the Table control.TableSelect
Versions 16 and later
tsColumn
New in version 16
tsColumn
tsColumn
Element taken into account:
  • Number of the selected column.
  • Number of selected columns.
TableSelect
TableSelectCount
Versions 16 and later
tsRow
New in version 16
tsRow
tsRow
Element taken into account:
  • Number of the selected row.
  • Number of selected rows.
TableSelect
TableSelectCount
WithAllConfigure the print of a Table control: Prints the table while taking all the options into account (corresponds to WithMultipageColumns + WithDate + WithNbRecords + WithNbPages + WithTitle)TablePrint
WithDateConfigure the print of a Table control: the date is printed at the top of page.TablePrint
WithMultipageColumnsConfigure the print of a Table control: if the Table control exceeds the page size, the columns are printed over several pages.TablePrint
WithNbPagesConfigure the print of a Table control: the number of pages is printed at the end of page.TablePrint
WithNbRecordsConfigure the print of a Table control: the number of records is printed at the end of document. The caption used corresponds to the caption defined for the counter (in the description of Table control).TablePrint
WithTitleConfigure the print of a Table control: the page title is printed at the top of page. If the title of Table control is not visible, prints the window title.TablePrint
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment