Data.DB.TFieldType
Delphi
TFieldType = (ftUnknown, ftString, ftSmallint, ftInteger, ftWord, // 0..4
ftBoolean, ftFloat, ftCurrency, ftBCD, ftDate, ftTime, ftDateTime, // 5..11
ftBytes, ftVarBytes, ftAutoInc, ftBlob, ftMemo, ftGraphic, ftFmtMemo, // 12..18
ftParadoxOle, ftDBaseOle, ftTypedBinary, ftCursor, ftFixedChar, ftWideString, // 19..24
ftLargeint, ftADT, ftArray, ftReference, ftDataSet, ftOraBlob, ftOraClob, // 25..31
ftVariant, ftInterface, ftIDispatch, ftGuid, ftTimeStamp, ftFMTBcd, // 32..37
ftFixedWideChar, ftWideMemo, ftOraTimeStamp, ftOraInterval, // 38..41
ftLongWord, ftShortint, ftByte, ftExtended, ftConnection, ftParams, ftStream, //42..48
ftTimeStampOffset, ftObject, ftSingle); //49..51
C++
enum DECLSPEC_DENUM TFieldType : unsigned char { ftUnknown, ftString, ftSmallint, ftInteger, ftWord, ftBoolean, ftFloat, ftCurrency, ftBCD, ftDate, ftTime, ftDateTime, ftBytes, ftVarBytes, ftAutoInc, ftBlob, ftMemo, ftGraphic, ftFmtMemo, ftParadoxOle, ftDBaseOle, ftTypedBinary, ftCursor, ftFixedChar, ftWideString, ftLargeint, ftADT, ftArray, ftReference, ftDataSet, ftOraBlob, ftOraClob, ftVariant, ftInterface, ftIDispatch, ftGuid, ftTimeStamp, ftFMTBcd, ftFixedWideChar, ftWideMemo, ftOraTimeStamp, ftOraInterval, ftLongWord, ftShortint, ftByte, ftExtended, ftConnection, ftParams, ftStream, ftTimeStampOffset, ftObject, ftSingle };
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
| enum | public | Data.DB.pas Data.DB.hpp |
Data.DB | Data.DB |
Description
TFieldType is a set of values that parallels the data types of fields in tables.
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 |
Int64 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. |
|
ftParams |
Field type for TParams |
|
ftStream |
Field type for the TStream parameter |
|
ftTimeStampOffset |
Timestamp field with time zone information |
|
ftObject |
Field type for TObject parameter; only for DataSnap |
|
ftSingle |
Single precision floating-point number |