oDataTable.SetArray sType, index, aArray
|sType||(String) Type of selected values in the table:|
"Row" - One row of the table is selected (i.e. the array must be 1-dimensional). The value index must be an integer.
index>=0 means the index of the selected row (zero-based index).
index=-2 means the last row.
"Col" - One column of the table is selected (i.e. the array must be 1-dimensional). The value index must be a String type or an integer.
If it is the String, then it is the column name.
If it is the integer, then index>=0 means the index of the selected column (zero-based index), index=-2 means the last column.
"All" - All table is selected (i.e. the array must be 2-dimensional). The value index must be set to the value Empty.
|index||(Variant) Index to the table whose meaning is defined by the sType parameter|
|aArray||(Array) Array value created for example by the GetArray method or by the VBScript function Array.|
If the number of items of the assigned array doesn't equal the number of selected items, then only those items that can be assigned, are assigned. The assignment always proceeds from the beginning (e.g. from the first item of the row) and if the array is "small", than not all items have to be assigned (e.g. nothing is assigned into the last items of the row).
"Read only" columns: Each cell is empty at the beginning. The cell is considered empty also if it contains numeric value 0 or an emty string "". New value can be written into such cell. After writing a non-zero value into the "Read only" column the cell is "locked". "Locked cell" becomes a constant and cannot be written again. Other still "unlocked" cells can be written into as needed. Methods that write into multiple cells simultaneously will write the values only into "unlocked cells" while the content of "locked" cells remains unchanged.
arr = Array("Param1", 1, 2.5, 4)
oDataTable.SetArray "Row", -2, arr