Skip to main content
Version: 20 R6 BETA

VP INSERT TABLE COLUMNS

History
ReleaseChanges
19 R7Added

VP INSERT TABLE COLUMNS ( vpAreaName : Text ; tableName : Text ; column : Integer {; count : Integer {; insertAfter : 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 insert
countText->Number of columns to add (must be >0)
insertAfterInteger->vk table insert before or vk table insert after column
sheetInteger->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:

ConstantValueDescription
vk table insert before0Insert column(s) before the column (default if omitted)
vk table insert after1Insert 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