sType | (String) Type of selected values in the table:
"col" - data from one or more table columns are returned (i.e. 1-dimensional array or matrix of data is created) depending on the value of the vWhat parameter.
|
---|---|
vWhat | (Variant) Specifies which columns values will be returned. The vWhat value must be a string, an integer or an array of integers.
If it is of the String type, then it is a column name or the string of column names separated by semicolon, for example, "col4;col5;col6".
If it is the integer, then vWhat>=0 means the index of the selected column (vWhat=0 means the first column, vWhat=-2 means the last column).
If vWhat is the array of integers, then these numbers specify indexes of table columns which data will be returned from.
"xxx" - vWhat is the text string specifying either the column name, for example col4 or the text string with column names separated by semicolon, for example "col4;col5;col6".
>=0 - integer >=0 means the index of the selected column (vWhat=0 means the first column).
-2 - The -2 value means that data from the last column are returned.
If vWhat is the array of integers, then these numbers specify indexes of table columns which data will be returned from. array - If vWhat is the array of integers (for example vWhat=Array(0,2,6)), then numbers in the array specify indexes of table columns which data will be returned from. |
arr = oDatabase.GetArray("col", "variable1");
arr = oDatabase.GetArray("col", 2);
arr = oDatabase.GetArray("col", "variable1;variable2");
var cols = Pm.Array1(0, 1, 2);
arr = oDatabase.GetArray("col", cols);