Sets a new value for a specific column with the data type long.

Syntax

XIH.SetLong(colcaption, value)
XIH.SetLong(colcaption, offset, value)
XIH.SetLong(colIndex, value)
XIH.SetLong(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

long

The new value that will replace the old one

"Huge_Integer"

Remarks

ColumnIndex is zero-based.

You can change your column to the data type long using an operation called "Format columns".

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 long that will be filled with the results.

XIH.SetLong("Sales", #Value# * 100)

Writes into the column "Sales" the value of column "Value" multiplied by 100.


XIH.SetLong("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.