Show: Delphi C++
Display Preferences

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

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



See Also

Personal tools
In Other Languages
Previous Versions
Assistance