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.

id%

Integer. The field ID.

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
See Also

GetValue method
FieldName method
IsValueAltered method
NumColumns property

Glossary