FieldID (ODBCResultSet - LotusScript)

Returns the field ID of a field as an integer value, given the field name.

Defined in

ODBCResultSet

Syntax

id% = odbcResultSet . FieldID( column$ )

Parameters

column$

String. The name of the field in the result set.

Return value

id%

Integer. The field ID.

Usage

The field ID in the result set corresponds to the relative column number; that is, the first column has a field ID of 1; the second column's field ID is 2; and so on.

The field ID is required only when you know the field name, but not the column ID. If the result set changes, a field's relative position, and consequently its ID, changes. Use FieldID to determine the field ID dynamically.

Errors

Invalid column (DBstsINVC)

Example