Property Reference > Quick Reference for All Properties > Type Property |
Field.Type
Notes
Read-only at run time. Unavailable at design time. Return type: enumeration (see below). Property applies to Field object. See OLE DB or ADO documentation for detailed description of these data types.
Description
This property returns the data type of the database field represented by this Field object.
Possible values of this property are the data types defined in OLE DB and ADO:
c1qTypeI2 = 2 |
Integer 16 bit |
c1qTypeI4 = 3 |
Integer 32 bit |
c1qTypeR4 = 4 |
Real 32 bit |
c1qTypeR8 = 5 |
Real 64 bit |
c1qTypeCurrency = 6 |
Currency |
c1qTypeDateTime = 7 |
Date |
c1qTypeBSTR = 8 |
String variable length |
c1qTypeBool = 11 |
Boolean |
c1qTypeVariant = 12 |
Variant |
c1qTypeDecimal = 14 |
Decimal |
c1qTypeI1 = 16 |
Integer 8 bit |
c1qTypeUI1 = 17 |
Unsigned integer 8 bit |
c1qTypeUI2 = 18 |
Unsigned integer 16 bit |
c1qTypeUI4 = 19 |
Unsigned integer 32 bit |
c1qTypeI8 = 20 |
Integer 64 bit |
c1qTypeUI8 = 21 |
Unsigned integer 64 bit |
c1qTypeGUID = 72 |
GUID |
c1qTypeString = 129 |
String fixed length |
c1qTypeWideString = 130 |
Wide string fixed length |
c1qTypeNumeric = 131 |
Numeric |
c1qTypeDate = 133 |
DB Date |
c1qTypeTime = 134 |
DB Time |
c1qTypeTimeStamp = 135 |
Time stamp |
c1qTypeFileTime = 64 |
File time |
c1qTypeDBFileTime = 137 |
DB file time |