|
|
|
|
|
- Use conditions
- Characteristics of a row
- Position of added row
- Limits: Maximum number of rows displayed
- Various
- Adding rows
- Cascading input
- Browsing Table or TreeView Table control: Modifications in the linked data file
- Browsing Table or TreeView Table control: Adding several rows
- Adding a record into a browsing Table control and releasing a trigger
- Browsing Table or TreeView Table control in edit
- Adding images
TableAdd (Function) In french: TableAjoute Adds a row into: - a Table control,
- a TreeView Table control,
a Combo Box control "with table" (Table control displayed in a Combo Box control).
- TAB characters into the columns,
- all types of values into the columns.
// Add "Moore", "Vince" and "06/21/72" // at the end of the "TABLE_CustomerTable" control ResAdd = TableAdd(TABLE_CustomerTable, "Moore" + TAB + "Vince" + TAB + "06/21/72")
Syntax
<Result> = TableAdd(<Table control> [, <Row>])
<Result>: Boolean - True if the element was added,
- False otherwise.
<Table control>: Control name Name of control to use. This control can correspond to: - a Table control.
- a TreeView Table control.
a Combo Box control with table. If this parameter corresponds to an empty string (""), the control to which the current event belongs will be used. <Row>: Optional character string Row to add. This row has the following format:
<Element of column 1> + TAB + <Element of column 2> + TAB + ...
If this parameter is not specified, an empty row is added into the control. For a browsing control, the default values defined in the linked data file are taken into account. Remarks Use conditions TableAdd can be used on: - a browsing or memory control,
- a single-selection or multiselection control.
Characteristics of a row - Each added element is converted into the type of the relevant column.
- To specify no value for an element, use an empty string ("") or 0 (according to the type of column). For example:
TableAdd(TABLE_CustomerTable, "Moore" + TAB + "Vince" + TAB + "" + TAB + "06/21/72")
- If an element corresponds to the calculation result, the numeric expression must be enclosed in brackets. For example:
TableAdd(TABLE_CalcTable, (53+29) + TAB + (83-21))
Position of added row By default, the row is added at the end of the rows displayed by the control. Special case: - If the control is sorted by TableSort, the added row is positioned in the control according to the current sort.
- If the control is sorted by the user, the sort is ignored when inserting the row. The row is added at the end of control.
Limits: Maximum number of rows displayed The maximum number of rows that can be displayed in a Table or TreeView Table control is limited by the amount of available memory (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). Various - To add a row at a specific position in a Table or TreeView Table control, use TableInsertLine.
- If the added row is the first row of the control, the added row becomes the current row.
Adding images To add an image into a Table or TreeView Table control: specify the name and full path of image to add. For example:
TableAdd(TABLE_MyTable, "C:\MyDocuments\MyImage.BMP")
Note: The column must be an Image column otherwise the added image will not be displayed properly.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|