Returns the value of the specified column as long.

Syntax

XIH.GetLong(colcaption)
XIH.GetLong(colcaption, offset)
XIH.GetLong(colIndex)
XIH.GetLong(colIndex, offset)

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

Remarks

ColumnIndex is zero-based.

A statement with an offset returns 0 after reaching the end of the column due to the offset.

If necessary, you can change your column to the data type long using an operation called "Format columns".

Use this function for numbers greater than 2.1 billion (max. of 32-Bit number, see also MSDN)

Returns a long value.

Examples

XIH.GetLong("Huge_Umsatz")
XIH.GetLong("Huge_Umsatz", 2)
XIH.GetLong(0)