Promotic
WikipediaLinkedInYoutubeTwitterFacebook

InsertRow - method of object PmDataTable

Description:
The method inserts new row (or more new rows) on the specified position. Existing rows after this position are moved. Cell values in new row are empty (Empty data type).
Syntax:
InsertRow(Row As Long, [Count As Long]) As Long
Calling:
oDataTable.InsertRow Row, Count
Parameters:
Row(Long) If the value of this parameter is >=0, then it is the row index (zero-based index) where the new row has to be inserted.

The value -2 means that new row has to be inserted at the end of the table.

Count[optional] (Long) Number of new rows. The preset value is 1.
Return Values:
Returns the index of the first inserted row. It returns the negative number if an error occurred (the row has not been inserted). Then the error is written into the INFO system.
Note:
Maximum number of rows depends on PROMOTIC Runtime License and is: PmRtProf: 65535, PmRtStandard: 50000, PmRtLite: 100, PmRtFree: 30

"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.

See also:
Example:
In the object "/Data/Params" (of the PmDataTable type) the following operations proceeds:
- One new row is inserted at the beginning (on the row with the index 0)
- Five new rows are inserted at the end of the table
Dim oDataTable
Set oDataTable = pMe.Pm("/Data/Params1")
oDataTable.InsertRow 0
oDataTable.InsertRow -2, 5
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice