FireDAC.Stan.Intf.TFDDataType

• Up to Parent: FireDAC.Stan.Intf

Delphi

TFDDataType = (dtUnknown,                                 // unknown
dtBoolean,                                              // Boolean
dtSByte, dtInt16, dtInt32, dtInt64,                     // signed int
dtByte, dtUInt16, dtUInt32, dtUInt64,                   // unsinged int
dtSingle, dtDouble, dtExtended,                         // float point numbers
dtCurrency, dtBCD, dtFmtBCD,                            // high-precision numbers
dtDateTime, dtTime, dtDate, dtDateTimeStamp,            // date and time
dtTimeIntervalFull, dtTimeIntervalYM, dtTimeIntervalDS, // time interval
dtAnsiString, dtWideString, dtByteString,               // string
dtBlob, dtMemo, dtWideMemo, dtXML,                      // value blobs
dtHBlob, dtHMemo, dtWideHMemo,                          // handle blobs
dtHBFile,                                               // external files
dtRowSetRef, dtCursorRef, dtRowRef,
dtArrayRef, dtParentRowRef,                           // adt -> ftDataSet, ftCursor, ftADT, ftArray
dtGUID, dtObject);                                      // adt -> IFDDataStoredObject

C++

enum DECLSPEC_DENUM TFDDataType : unsigned int { dtUnknown, dtBoolean, dtSByte, dtInt16, dtInt32, dtInt64, dtByte, dtUInt16, dtUInt32, dtUInt64, dtSingle, dtDouble, dtExtended, dtCurrency, dtBCD, dtFmtBCD, dtDateTime, dtTime, dtDate, dtDateTimeStamp, dtTimeIntervalFull, dtTimeIntervalYM, dtTimeIntervalDS, dtAnsiString, dtWideString, dtByteString, dtBlob, dtMemo, dtWideMemo, dtXML, dtHBlob, dtHMemo, dtWideHMemo, dtHBFile, dtRowSetRef, dtCursorRef, dtRowRef, dtArrayRef, dtParentRowRef, dtGUID, dtObject };

Properties

Type	Visibility	Source	Unit	Parent
enum	public	FireDAC.Stan.Intf.pas FireDAC.Stan.Intf.hpp	FireDAC.Stan.Intf	FireDAC.Stan.Intf

Description

TFDDataType is a set of values that parallels the data types of fields in tables.

TFDDataType type is the set of values for the DataType property of many FireDAC classes.

The following table describes each value:

Value	Description
dtAnsiString	ANSI string.
dtArrayRef	Reference to an array.
dtBCD	Binary-coded decimal number that can be converted to currency type without a loss of precision.
dtBlob	Large binary object.
dtBoolean	Boolean.
dtByte	8-bit unsigned integer.
dtByteString	Array of bytes.
dtCurrency	Currency number.
dtCursorRef	Reference to a cursor.
dtDate	Date.
dtDateTime	Date and time.
dtDateTimeStamp	Date and time as Unix time.
dtDouble	Double-precision floating-point number.
dtExtended	Extended-precision floating-point number.
dtFMTBcd	Binary-coded decimal number that is too large for dtBCD.
dtGUID	Globally unique identifier.
dtHBFile	Handle of a binary file.
dtHBlob	Handle of a large binary object.
dtHMemo	Handle of a memo of ANSI string.
dtHWideMemo	Handle of a memo of wide string.
dtInt16	16-bit signed integer.
dtInt32	32-bit signed integer.
dtInt64	64-bit signed integer.
dtMemo	Memo of ANSI string.
dtObject	Instance of TObject. Only for DataSnap.
dtParentRowRef	Reference to a parent row.
dtRowRef	Reference to a row.
dtRowSetRef	Reference to a row set.
dtSByte	8-bit signed integer.
dtSingle	Single-precision floating-point number.
dtTime	Time.
dtTimeIntervalDS	Period of time in terms of days, hours, minutes, and seconds. It is equivalent to dtTimeIntervalFull.
dtTimeIntervalFull	Period of time in terms of days, hours, minutes, and seconds. It is equivalent to dtTimeIntervalDS.
dtTimeIntervalYM	Period of time in terms of years and months.
dtUInt16	16-bit unsigned integer.
dtUInt32	32-bit unsigned integer.
dtUInt64	64-bit unsigned integer.
dtUnknown	Unknown or undetermined.
dtWideString	Wide string.
dtWideMemo	Memo of wide string.
dtXML	XML data.

See Also

• FireDAC.Stan.Intf.TFDDataTypes

• Data.DB.TFieldType