ADOQuery.Fields[i].DataType是一个 TFieldType类型的 TFieldType = (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);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 Large integer fieldftADT 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.
TFieldType = (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);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 Large integer fieldftADT 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.
中间的i为你的字段名!
如:ADOQuery1.Fields[0].DataType