ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2024

Category: Table functions
154 results
Adds a row in:
  • a Table control,
  • a TreeView Table control,
  • a Combo Box control "with table" (Table control displayed in a Combo Box control).
Adds elements on the right of an Horizontal Table control.
Modifies or returns the visibility status of internal wait window when adding additional elements into an infinite Table control.
Adds a row in:
  • a Table control,
  • a TreeView Table control.
Adds a row to a Table or TreeView Table control with an animation.
Adds a column title-header into a Table or TreeView Table control in a window.
Adjusts the title and size of columns found in a Table or TreeView Table control.
Returns the index of the break header and footer for a given break in a Table control.
Returns the coordinates (row number and column number) of a selected cell. This function is kept for backward compatibility. It is recommended to use TableSelect.
Returns the number of selected cells found in a Table control. This function is kept for backward compatibility. It is recommended to use TableSelectCount.
Collapses:
  • the entire hierarchy (all nodes) of a TreeView Table control.
  • all breaks of a Table control.
Collapses or expands an element in a Table or TreeView Table control.
Returns the index of a column in a Table or Treeview Table control.
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.
Deletes a row from:
  • a Table control,
  • a TreeView Table control,
  • a table displayed in a Combo Box control.
Deletes all rows from:
  • a Table control populated programmatically,
  • a TreeView Table control populated programmatically,
  • tables displayed in a Combo Box control.
Deletes the selected rows from a Table or Treeview Table control.
Deletes a row from a Table control, from a TreeView Table control (or from a table displayed in a Combo Box control) with an animation.
Disables a user filter on a column or on all the columns found in a Table or TreeView Table control.
Refreshes a Table or TeeeView Table control from a given position:
  • for a control linked to a file: changes made in the linked data file are reflected in the control.
  • for a control handled programmatically: the calculated columns are re-calculated.
Stops the manual iteration of data file linked to a Table control based on a data file.
Ends the process to populate a Table or TreeView Table control programmatically.
Enumerates the breaks found in a Table control.
Returns the name of a column found in a Table or Treeview Table control.
Expands:
  • a branch that was previously collapsed in a TreeView Table control.
  • a branch that was previously collapsed in a Table control.
  • a detailed window displayed for a row.
Expands:
  • the entire hierarchy (all nodes) of a TreeView Table control.
  • all breaks of a Table control.
Returns the list of columns filtered by the user in a Table or TreeView Table control.
Fixes a column to the left or frees a column fixed to the left.
Adds a calculated row to a Table control by providing custom calculation procedures.
Deletes all rows added with <Table>.FormulaAdd.
Returns for a given position in a Table or TreeView Table control (coordinates of a control point):
  • the name of the column displayed for the specified position.
  • the index of the row or column for the specified position.
Indicates whether a Table or TreeView Table control is currently in edit.
Enables input in the search area in the column title of the Table or Treeview Table control.
Inserts a row into:
  • a Table control,
  • a TreeView Table control,
  • a table displayed in a Combo Box control.
Inserts elements in the format of columns into a horizontal Table control.
Inserts a row into:
  • a Table control,
  • a TreeView Table control.
Inserts a row into a Table control or into a TreeView Table control with an animation.
Modifies a row in:
  • a Table control,
  • a TreeView Table control,
  • a table displayed in a Combo Box control.
Modifies a column in a horizontal Table control.
Modifies a row in:
  • a Table control,
  • a TreeView Table control.
Moves a column in a Table or TreeView Table control.
Moves a row or swaps two rows in a Table control.
Displays a Table or TreeView Table control from a specified row or returns the index of the first row displayed in a Table or TreeView Table control.
Prints the content of the specified Table control without having to create a report based on the Table control.
Returns the number of the current record in a Table control based on a data file.
Modifies or returns the visibility status of refresh bar in a Table or TreeView Table control.
Restores the scrollbar position in a Table or TreeView Table control as well as the selected elements.
Updates or adds the record bound to the current row in the Table or TreeView Table control.
Save:
  • the scrollbar position in a Table or TreeView Table control,
  • the elements selected in the control.
Searches for a value in all the columns of the following controls:
  • Table control,
  • TreeView Table control,
  • Table control displayed in a Combo Box control.
Returns the index of the selected element in the Table or TreeView Table control.
Returns the number of selected elements in a Table or TreeView Table control (especially multi-selection controls).
Deselects a row from a Table or TreeView Table control.
Selects a row in a Table or TreeView Table control.
Positions on the data file record corresponding to a row selected in the multi-selection Table control based on a data file.
Gives focus to a row found in a Table or TreeView Table control: the control switches to edit for the specified row and column.
Sorts a Table or TreeView Table control on one or more columns (lexicographical sort).
Returns the list of sorted columns found in a table.
Starts the process to populate a Table or TreeView Table control programmatically.
Swaps:
  • two rows in a Table control populated programmatically.
  • two branches in a Treeview Table control populated programmatically.
Copies the content of a Table or TreeView Table control to the clipboard.
Creates an Excel file with the data from a Table or TreeView Table control.
Creates a character string from the data found in a Table or TreeView Table control.
Creates a Word file (.RTF) from the data found in a Table or TreeView Table control.
Creates an XML file from the data found in a Table or TreeView Table control.
Searches for a value in a column of a TreeView Table control, in a specified branch.
Adds a row into a TreeView Table control, at the end of a given hierarchy level.
Returns the number of direct children for an element in a TreeView Table control.
Deletes all child rows from a branch of the hierarchy.
Returns the "children" of an element (lower level) in a TreeView Table control.
Returns the "parent" of an element in a TreeView Table control.
Inserts a row into a TreeView Table control, in a given hierarchy level.
Returns the status of a node in a Treeview Table control: collapsed, expanded or not found.
Lists the "children" of a node and the "child" elements of these "children" in a TreeView Table control.
Moves the content of a row as well as its entire descending tree structure in a TreeView Table control.
Sorts a branch in a TreeView Table control on one or more columns.
Swaps the content of two rows (as well as their respective tree structure) in a TreeView Table control.
Checks the existence of an element in a TreeView Table and returns its type (node or leaf) if the element exists.
Usage example of the BuildBrowsingTable function
Creates a Table control from the items of a data file (view or query).
List of constants used by the functions for managing Table, TreeView Table, Looper and List Box controls.
Populates a Table control programmatically with the records from a data file, HFSQL view or query (query created in the query editor or with HExecuteSQLQuery).
List of functions for managing Table controls (prefix syntax)
List of functions specific to Table controls
Adds a row in:
  • a Table control,
  • a TreeView Table control,
  • a Combo Box control "with table" (Table control displayed in a Combo Box control).
Adds elements on the right of an Horizontal Table control.
Modifies or returns the visibility status of internal wait window when adding additional elements into an infinite Table control.
Adds a row in:
  • a Table control,
  • a TreeView Table control.
Adds a row to a Table or TreeView Table control with an animation.
Adds a column title-header into a Table or TreeView Table control in a window.
Adjusts the title and size of columns found in a Table or TreeView Table control.
Use example for the TableBreakIndex function
Returns the index of the break header and footer for a given break in a Table control.
Returns the coordinates (row number and column number) of a selected cell. This function is kept for backward compatibility. It is recommended to use TableSelect.
Returns the number of selected cells found in a Table control. This function is kept for backward compatibility. It is recommended to use TableSelectCount.
Collapses or expands an element in a Table or TreeView Table control.
Returns the index of a column in a Table or Treeview Table control.
Returns the column number corresponding to one of the columns selected in the Table control. This function is kept for backward compatibility. It is recommended to use TableSelect.
Returns the number of selected columns found in a table. This function is kept for backward compatibility. It is recommended to use TableSelectCount.
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.
Deletes a row from:
  • a Table control,
  • a TreeView Table control,
  • a table displayed in a Combo Box control.
Deletes all rows from:
  • a Table control populated programmatically,
  • a TreeView Table control populated programmatically,
  • a table displayed in a Combo Box control.
Deletes the selected rows from a Table or Treeview Table control.
Deletes a row from a Table control, from a TreeView Table control (or from a table displayed in a Combo Box control) with an animation.
Disables a user filter on a column or on all the columns found in a Table or TreeView Table control.
Refreshes a Table or TeeeView Table control from a given position:
  • for a control linked to a file: changes made in the linked data file are reflected in the control.
  • for a control handled programmatically: the calculated columns are re-calculated.
Implements a user filter on a column found in a Table or TreeView Table control.
Stops the manual iteration of data file linked to a Table control based on a data file.
Ends the process to populate a Table or TreeView Table control programmatically.
Collapses:
  • a branch that was previously expanded in a TreeView Table control.
  • a break that was previously expanded in a Table control.
  • a detailed window displayed for a row.
Enumerates the breaks found in a Table control.
Returns the name of a column found in a Table or Treeview Table control.
Returns the list of columns filtered by the user in a Table or TreeView Table control.
Fixes a column to the left or frees a column fixed to the left.
Adds a calculated row to a Table control by providing custom calculation procedures.
Deletes all formulas added with TableFormulaAdd.
Usage example of the TableInfoXY function
Returns for a given position in a Table or TreeView Table control (coordinates of a control point):
  • the name of the column displayed for the specified position.
  • the index of the row or column for the specified position.
Indicates whether a Table or TreeView Table control is currently in edit.
Enables input in the the search area in the column title of the Table or Treeview Table control.
Inserts a row into:
  • a Table control,
  • a TreeView Table control,
  • a table displayed in a Combo Box control.
Inserts elements in the format of columns into a horizontal Table control.
Inserts a row into:
  • a Table control,
  • a TreeView Table control.
Inserts a row into a Table control or into a TreeView Table control with an animation.
TableMode is kept for backward compatibility.
Modifies a row in:
  • a Table control,
  • a TreeView Table control,
  • a table displayed in a Combo Box control.
Modifies a column in a horizontal Table control.
Modifies a row in:
  • a Table control,
  • a TreeView Table control.
Moves a column in a Table or TreeView Table control.
Moves a row or swaps two rows in a Table control.
Displays a Table or TreeView Table control from a specified row or returns the index of the first row displayed in a Table or TreeView Table control.
Prints the content of the specified Table control without having to create a report based on the Table control.
Returns the number of the current record in a Table control based on a data file.
Modifies or returns the visibility status of refresh bar in a Table or TreeView Table control.
Restores the scrollbar position in a Table or TreeView Table control as well as the selected elements.
Updates or adds the record bound to the current row in the Table or TreeView Table control.
Saves:
  • the scrollbar position in a Table or TreeView Table control,
  • the elements selected in the control.
Performs a search in:
  • a Table control,
  • a TreeView Table control,
  • a table displayed in a Combo Box control.
Searches for a value in all the columns of the following controls:
  • Table control,
  • TreeView Table control,
  • Table control displayed in a Combo Box control.
Returns the index of the selected element in the Table or TreeView Table control.
Returns the number of selected elements in a Table or TreeView Table control (especially multi-selection controls).
Deselects a row from a Table or TreeView Table control.
Selects a row in a Table or TreeView Table control.
Positions on the data file record corresponding to a row selected in the multiselection browsing Table control.
Gives focus to a row found in a Table or TreeView Table control: the control switches to edit for the specified row and column.
Sorts a Table or TreeView Table control on one or more columns (lexicographical sort).
Returns the list of sorted columns found in a Table control.
Starts the process to populate a Table or TreeView Table control programmatically.
Swaps:
  • two rows in a Table control populated programmatically.
  • two branches in a Treeview Table control populated programmatically.
Copies the content of a Table or TreeView Table control to the clipboard.
Creates an Excel file with the data from a Table or TreeView Table control.
Creates a character string from the data found in a Table or TreeView Table control.
Creates a Word file (.RTF) from the data found in a Table or TreeView Table control.
Creates an XML file from the data found in a Table or TreeView Table control.