Promotic
WikipediaLinkedInYoutubeTwitterFacebook

GetArray - method of the PmaDataTable object

Description:
Creates an array of values from selected data items of the object.
Syntax:
Array GetArray(String sType, Variant index)
Calling:
array = oDataTable.GetArray(sType, index)
Parameters:
sType(String) Type of selected values in the table:
"Row" - One row of the table is selected (i.e. 1-dimensional array is created).

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. 1-dimensional array is created).

The value index must be of the String type or of the Integer type:

- If it is of the String type, then it is the column name.
- If it is of the Integer type, then index>=0 means the index of the selected column (zero-based index), index=-2 means the last column.

"Table" - The whole table is selected in the form of an array of rows (i.e. a 2-dimensional array is created as default Col,Row). See (Col,Row) - 2-dimensional array meaning an array of rows.

The value index must be set to the value: null for JavaScript or Empty pro VBScript.

"All" - Caution! The whole table is selected in the form of an array of columns (i.e. a 2-dimensional array is created as default Row,Col).

The value index must be set to the value: null for JavaScript or Empty pro VBScript.

index(Variant) Index to the table whose meaning is defined by the sType parameter.
Example:
1-dimensional array containing values from the second row is assigned into the arr variable:
JavaScriptVBScriptSelect and copy to clipboard

var oDataTable = pMe.Pm("/DataTable");
var arr = oDataTable.GetArray("Row", 1);
PROMOTIC 9.0.12 SCADA system documentation - MICROSYS, spol. s r.o.

Send page remarkContact responsible person
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice