Sets a new value for a specific column with the data type double.
Syntax
XIH.SetDouble(colcaption, value)
XIH.SetDouble(colcaption, offset, value)
XIH.SetDouble(colIndex, value)
XIH.SetDouble(colIndex, offset, value)
Parameters
Parameter | Data type | Description | Sample |
---|---|---|---|
colcaption | string | String specifies the columns caption. | "col1" |
colIndex | int | Index of a column | 1 |
offset | int | Optionally specifies the row offset. Default is 1 | 1 |
value | double | The new value that will replace the old one | 3.5 |
Remarks
ColumnIndex is zero-based.
A statement with an offset returns 'false' after reaching the end of the column due to the offset.
Returns a boolean.
Examples
For this example to work you need an existing column "Value" that is filled with numbers and an existing column "Sales" with the data type double that will be filled with the results.
XIH.SetDouble(
"Sales"
, #Value# * 100.00)
Writes into the column "Sales" the value of column "Value" multiplied by 100.
XIH.SetDouble(
"Sales"
, 2, #Value#)
Writes the current value of column "Value" offset by 2 rows into the column "Sales".
Returns 'false' after reaching the end of the table due to the offset.
Related
- TIS Parameters
- XIH Functions