GetColumnType

Description

Returns the type of data stored in the specified column.

This method returns the underlying database type, rather than a FieldType, because the result of a complex SQL query can include a column that does not correspond to a field of a record.

Columns are numbered from 1 to N, not 0 to N-1.

Syntax

VBScript


resultset.GetColumnType columnNum 

Perl


$resultset->GetColumnType(columnNum); 
Identifier
Description
resultset
A ResultSet object, representing the rows and columns of data resulting from a query.
columnNum
A Long that specifies the desired index (1-based) into the array of columns.
Return value
A Long whose value is a CType enumeration constant representing this column's underlying storage type in the database.