Tfield Type type

Description

TFieldType type is the set of values for the DataType property field objects, field definition objects, and parameter objects. Classes in which TFieldType values are used include TField (and descendants), TFieldDef, TParam, TParameter, and TAggregate. TFieldType values are also used in field-related functions and methods like the Add method of TFieldDefs. The following table describes each value:

Value Description

===================================================================================================

ftUnknown Unknown or undetermined

ftString Character or string field

ftSmallint 16-bit integer field

ftInteger 32-bit integer field

ftWord 16-bit unsigned integer field

ftBoolean Boolean field

ftFloat Floating-point numeric field

ftCurrency Money field

ftBCD Binary-Coded Decimal field that can be converted to Currency type without a loss of precision.

ftDate Date field

ftTime Time field

ftDateTime Date and time field

ftBytes Fixed number of bytes (binary storage)

ftVarBytes Variable number of bytes (binary storage)

ftAutoInc Auto-incrementing 32-bit integer counter field

ftBlob Binary Large OBject field

ftMemo Text memo field

ftGraphic Bitmap field

ftFmtMemo Formatted text memo field

ftParadoxOle Paradox OLE field

ftDBaseOle dBASE OLE field

ftTypedBinary Typed binary field

ftCursor Output cursor from an Oracle stored procedure (TParam only)

ftFixedChar Fixed character field

ftWideString Wide string field

ftLargeint Large integer field

ftADT Abstract Data Type field

ftArray Array field

ftReference REF field

ftDataSet DataSet field

ftOraBlob BLOB fields in Oracle 8 tables

ftOraClob CLOB fields in Oracle 8 tables

ftVariant Data of unknown or undetermined type

ftInterface References to interfaces (IUnknown)

ftIDispatch References to IDispatch interfaces

ftGuid globally unique identifier (GUID) values

ftTimeStamp Date and time field accessed through dbExpress

ftFMTBcd Binary-Coded Decimal field that is too large for ftBCD.