RecordSet.ColumnType

Method

RecordSet.ColumnType ( Index as Integer ) As Integer

Returns the data type of the passed column. The index parameter is 0-based.

Notes

Please refer to the table of field types in the Database class notes for the numeric values corresponding to SQL data types.

Refer to the definitions in Database.FieldSchema for details on the column types used by the method.

The following gets the columntype of the ith column in the passed recordset.

Dim i As Integer

For i = 0 To rs.FieldCount
i = rs.ColumnType(i)
//take conditional actions on the returned column types

Next