|
|
|
|
|
|
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 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.
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|