NOP Design Home Page
Documentation
TOC/Index
Search
Downloads



GetColumntype

Determine the data-type of a rowset column

GetColumnType ColumnType As 10 From MyRowset

Actual values may vary based on database provider. Possible values inlude: "CHAR" "VARCHAR" "LONGVARCHAR" "WCHAR" "WVARCHAR" "WLONGVARCHAR" "DECIMAL" "NUMERIC" "SMALLINT" "INTEGER" "REAL" "FLOAT" "DOUBLE" "BIT" "TINYINT" "BIGINT" "BINARY" "VARBINARY" "LONGVARBINARY" "DATE" "TIME" "TIMESTAMP" "GUID" "UNKNOWN"

Minimum version: 1.0