VP REMOVE TABLE COLUMNS
History
| Release | Changes |
|---|---|
| 19 R7 | Added |
VP REMOVE TABLE COLUMNS ( vpAreaName : Text ; tableName : Text ; column : Integer {; count : 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 remove |
| count | Integer | -> | Number of columns to remove (must be >0) |
| sheet | Integer | -> | Sheet index (current sheet if omitted) |
Description
The VP REMOVE TABLE COLUMNS command removes one or count column(s) in the specified tableName at the specified column index. The command removes values and styles.
The command removes columns from the tableName table, NOT from 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 letf according to the number of removed columns.
If tableName does not exist, nothing happens.
Example
To remove two columns from 3rd column of the "dataTable" table:
VP REMOVE TABLE COLUMNS("ViewProArea"; "dataTable"; 3; 2)