Skip to main content
Version: 20 R6 BETA

VP REMOVE TABLE COLUMNS

History
ReleaseChanges
19 R7Added

VP REMOVE TABLE COLUMNS ( vpAreaName : Text ; tableName : Text ; column : Integer {; count : Integer {; sheet : Integer }}} )

ParameterTypeDescription
vpAreaNameText->4D View Pro area form object name
tableNameText->Table name
columnInteger->Index in the table of the starting column to remove
countText->Number of columns to remove (must be >0)
sheetInteger->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)

See also

VP INSERT TABLE COLUMNS
VP REMOVE TABLE ROWS