|
|
|
|
|
|
|
|
|
|
- Characteristics of inserted row
- Position of inserted row
- Limits: Maximum number of lines displayed
- Miscellaneous
- Inserting images
TableInsert (Function) In french: TableInsère Inserts a row into: - a Table control,
- a TreeView Table control,
Remarks:
ResInsertion = TableInsert(TABLE_TableClient, "Paul" + TAB + "Dubois", 5)
Syntax
<Result> = TableInsert(<Table control> [, <Row> [, <Index>]])
<Result>: Boolean - True if the element was inserted,
- False otherwise.
<Table control>: Control name Name of the control to be used. This control can correspond to: - a Table control.
- a TreeView Table control.
If this parameter corresponds to an empty string (""), the control used will be the control to which the current event belongs. <Row>: Optional character string Row to insert. This row has the following format:
<Element column1> + TAB + <Element column2> + TAB + ...
If this parameter is not specified, an empty row is inserted into the control. For a data-bound control, the default values defined in the linked data file are taken into account. <Index>: Optional integer Index of the row to insert. The index of the first row is set to 1. | | | Index not specified | The row will be inserted before the current row. If no row is selected, the row is inserted at the bottom of the control. | | Index greater than the number of control rows. | The row is inserted at the bottom of the control. | | Index equal to 0 | The row is inserted at the beginning of the control. | | Index equal to -1 | The row will be inserted before the current row. |
Remarks TableInsert can be used on: - Table or TreeView Table controls based on a data file.
- Table or TreeView Table controls populated programmatically.
- single-selection or multi-selection controls.
Characteristics of inserted row - Each inserted element is converted into the type of relevant column.
- If you don't want to specify a value for an element, use an empty string ("") or 0 (depending on the column type). For example:
TableInsert(TABLE_TableClient, "Dubois" + TAB + "Pierre" + TAB + "" + TAB + "21/06/72")
- If an element corresponds to the result of a calculation, enclose the numerical expression in brackets. For example:
TableInsert(TABLE_TableCalcul, (53+29) + TAB + (83-21))
Position of inserted row By default, the row is inserted at the specified position. Special cases: - If the control is sorted with TableSort, the new row is positioned according to the current sort and not the specified index.
- If the control is sorted by the user, the sort is ignored when inserting the row. The row is inserted at the specified position.
Limits: Maximum number of lines displayed The maximum number of rows that can be displayed in a TreeView Table control or hierarchical Table is limited only by available RAM (theoretical maximum: 2 billion rows). However, we do not advise you to use large Table or TreeView Table controls for performance and user-friendliness reasons (time required to fill the control for example). Miscellaneous To add rows at the end of a Table or TreeView Table control, use TableAddLine. Inserting images To insert an image into a Table control: Note: To correctly display the added image, the column must be of type Image.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|