|
|
|
|
|
|
Category: Table functions |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 a row at the top of an Infinite Table control. The row is inserted before the first row of the Table control. The scroll position of the Table control doesn't change. |
|
|
|
|
|
|
Adds elements on the right of an Horizontal Table control. |
|
|
|
|
|
|
Gets or sets the display mode of the internal loading window used when additional elements are loaded in 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 field linked to a file: changes made to the linked table are reflected in the field..
- for a programmatically manipulated field: 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 or not a Table or TreeView Table control is in edit mode. |
|
|
|
|
|
|
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,
- tables 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,
- tables 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.
|
|
|
|
|
|
|
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 table record corresponding to a row selected in the multi-selection data-bound Table control.
|
|
|
|
|
|
|
Gives focus to a line in a Table or hierarchical Table field: the field switches to input for the specified line 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 (next level down) in a TreeView Table control. |
|
|
|
|
|
|
Returns the "parent" of an element (next level up) in a TreeView Table control. |
|
|
|
|
|
|
Inserts a row into a TreeView Table control, in a given hierarchy level. |
|
|
|
|
|
|
Returns the state of a node in a TreeView Table control: rolled up, unrolled or non-existent.
|
|
|
|
|
|
|
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 table (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 table, 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 a row at the top of an Infinite Table control. The row is inserted before the first row of the Table control. The scroll position of the Table control doesn't change. |
|
|
|
|
|
|
Adds elements on the right of an Horizontal Table control. |
|
|
|
|
|
|
Gets or sets the display mode of the internal loading window used when additional elements are loaded in 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 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,
- 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 field linked to a file: changes made to the linked table are reflected in the field..
- for a programmatically manipulated field: 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 table linked to a data-bound Table control. |
|
|
|
|
|
|
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. |
|
|
|
|
|
|
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 or not a Table or TreeView Table control is in edit mode. |
|
|
|
|
|
|
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,
- tables 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,
- tables 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 data-bound Table control based on a table. |
|
|
|
|
|
|
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,
- tables 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 table record corresponding to a row selected in the multi-selection data-bound Table control. |
|
|
|
|
|
|
Gives focus to a line in a Table or hierarchical Table field: the field switches to input for the specified line 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. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|