Returns the value of the specified column as Int32.

Syntax

XIH.GetInt(colcaption)
XIH.GetInt(colcaption, offset)
XIH.GetInt(colIndex)
XIH.GetInt(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 an even number if the value lies exactly between two integers (e.g., 4.5 turns to 4 and 5.5 to 6).

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

Can convert: double and boolean.

Returns an Int32 value.

Examples

XIH.GetInt("Umsatz")
XIH.GetInt("Umsatz", 2)
XIH.GetInt(0)