oDataTable.InsertCol Col, Name, Dt
|Col||(Long) If the value of this parameter is >=0, then it is the column index (zero-based index) where the new column has to be inserted. |
The value -2 means that new column has to be inserted at the end of the table.
|Name||(String) Name of the new column. Already existing columns in this table mustn't have this name.|
|Dt||(Long) Data type of the column. See VBScript constants of data types.|
"Read only" columns: If any cell is locked in "Read only" column by writing non-empty value the the whole structure of the table is locked. Then it is no longer possible to add or remove rows or columns or change the structure of the table. The structure and dimensions of the table must be defined and modified before writing first non-empty value into a cell in "Read only" column.
Caution! New column can be inserted after the column with data type Identifier (if present).
oDataTable.InsertCol -2, "abc", vbLong