Promotic

GetCellValue - method of the PmaDataTable object

Description:
Returns a value of the table cell.
Syntax:
Variant GetCellValue(Variant Row, Variant Col, [String sParams])
Parameters:
Row(Variant) Specifies the cell row in the table either by index (number) or by the row identifikator (text string, first character must be a letter, case sensitive text).
If is >=0, then it is the row index (zero-based index).
If is -2, then it means the last row.
If is -3, then sets the value in all rows of the selected column.
 
Caution! Row identifier can be used only if the first column of the table is of the Identifier data type.
Col(Variant) Specifies the cell column in the table either by index (number) or by the identifikator of the column (text string, first character must be a letter, case sensitive text).
If is >=0, then it is the column index (zero-based index).
If is -2, then it means the last column.
If is -3, then sets the value in all columns of the selected row.
sParams[optional] (String) Specifies the behavior of the method in more detail. Entries are in the KeyVal format, for example "row:id;".
row (optional) - Specifies the meaning of the parameter Row.
id - The Row parameter will always represent the identifier of the row (also as number).
Note:
The value of this property can be also obtained in the "PmaRoot" item of the INFO system (when looking into the object with this property). This property can be changed in the INFO system by clicking the "Actions" button. See "PmaRoot > Permissions > InfoEdit" permission.
See also:
Example:
Reading value from table cell from row on the index and column on the index into the v1 variable and reading value from cell located on row named temperature and in column named value into the v2 variable.
JavaScriptVBScriptSelect and copy to clipboard

var oDataTable = pMe.Pm("/DataTable");
var v1 = oDataTable.GetCellValue(0, 0);
var v2 = oDataTable.GetCellValue("temperature", "value");

History:
Pm9.00.25: New sParams parameter. Specifies the behavior of the method in more detail.
Pm9.00.00: Created
PROMOTIC 9.0.27 SCADA system documentation MICROSYS, spol. s r.o.

Send page remarkContact responsible person
© MICROSYS, spol. s r.o.