Data.DB.TFieldType

From RAD Studio API Documentation
Jump to: navigation, search

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


See Also