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 |
---|---|
ftADT |
Abstract Data Type field |
ftArray |
Array field |
ftAutoInc |
Auto-incrementing 32-bit integer counter field |
ftBCD |
Binary-coded Decimal field that can be converted to Currency type without a loss of precision. |
ftBlob |
Binary Large OBject field |
ftBoolean |
Boolean field |
ftBytes |
Fixed number of bytes (binary storage) |
ftByte |
Field containing a byte value |
ftConnection |
Connection field |
ftCurrency |
Money field |
ftCursor |
Output cursor from an Oracle stored procedure (TParam only) |
ftDataSet |
DataSet field |
ftDate |
Date field |
ftDateTime |
Date and time field |
ftDBaseOle |
dBASE OLE field |
ftExtended |
Highest precision floating-point field |
ftFixedChar |
Fixed character field |
ftFixedWideChar |
Large string field of a fixed size |
ftFloat |
Floating-point numeric field |
ftFMTBcd |
Binary-coded decimal field that is too large for ftBCD. |
ftFmtMemo |
Formatted text memo field |
ftGraphic |
Bitmap field |
ftGuid |
Globally unique identifier (GUID) values |
ftIDispatch |
References to IDispatch interfaces |
ftInteger |
32-bit integer field |
ftInterface |
References to interfaces (IUnknown) |
ftLargeint |
Int64 large integer field |
ftLongWord |
32-bit positive integer field |
ftMemo |
Text memo field |
ftObject |
Field type for TObject parameter; only for DataSnap |
ftOraBlob |
BLOB fields in Oracle 8 tables |
ftOraClob |
CLOB fields in Oracle 8 tables |
ftOraInterval |
A time interval value, as defined by the Oracle database |
ftOraTimeStamp |
A timestamp value, as defined by the Oracle database |
ftParadoxOle |
Paradox OLE field |
ftParams |
Field type for TParams |
ftReference |
REF field |
ftSingle |
Single precision floating-point number |
ftShortint |
Small Integer field |
ftSmallint |
16-bit integer field |
ftStream |
Field type for the TStream parameter |
ftString |
Character or string field |
ftTime |
Time field |
ftTimeStamp |
Date and time field accessed through dbExpress |
ftTimeStampOffset |
Timestamp field with time zone information |
ftTypedBinary |
Typed binary field |
ftUnknown |
Unknown or undetermined |
ftVarBytes |
Variable number of bytes (binary storage) |
ftVariant |
Data of unknown or undetermined type |
ftWideMemo |
Wide memo field |
ftWideString |
Wide string field |
ftWord |
16-bit unsigned integer field |