VP INSERT TABLE COLUMNS
History
| Release | Changes |
|---|---|
| 19 R7 | Added |
VP INSERT TABLE COLUMNS ( vpAreaName : Text ; tableName : Text ; column : Integer {; count : Integer {; insertAfter : Integer {; sheet : Integer }}} )
| Parameter | Type | Description | |
|---|---|---|---|
| vpAreaName | Text | -> | 4D View Pro area form object name |
| tableName | Text | -> | Table name |
| column | Integer | -> | Index in the table of the starting column to insert |
| count | Text | -> | Number of columns to add (must be >0) |
| insertAfter | Integer | -> | vk table insert before or vk table insert after column |
| sheet | Integer | -> | Sheet index (current sheet if omitted) |
Description
The VP INSERT TABLE COLUMNS command inserts one or count empty column(s) in the specified tableName at the specified column index.
When a column has been inserted with this command, you typically modify its contents using the VP SET TABLE COLUMN ATTRIBUTES command.
In the insertAfter parameter, you can pass one of the following constants to indicate if the column(s) must be inserted before or after the column index:
| Constant | Value | Description |
|---|---|---|
vk table insert before | 0 | Insert column(s) before the column (default if omitted) |
vk table insert after | 1 | Insert column(s) after the column |
This command inserts some columns in the tableName table, NOT in the sheet. The total number of columns of the sheet is not impacted by the command. Data present at the right of the table (if any) are automatically moved right according to the number of added columns.
If tableName does not exist or if there is not enough space in the sheet, nothing happens.
Example
See examples for VP INSERT TABLE ROWS and VP SET TABLE COLUMN ATTRIBUTES.
See also
VP INSERT TABLE ROWS
VP REMOVE TABLE COLUMNS
VP SET TABLE COLUMN ATTRIBUTES