CODBCFieldInfo Structure

The CODBCFieldInfo structure has the following form:

struct CODBCFieldInfo
{
   CString m_strName;
   SWORD m_nSQLType;
   UDWORD m_nPrecision;
   SWORD m_nScale;
   SWORD m_nNullability;
};

The CODBCFieldInfo structure contains information about the fields in an ODBC data source. To retrieve this information, call CRecordset::GetODBCFieldInfo.

Members

m_strName

The name of the field.

m_nSQLType

The SQL data type of the field. This can be an ODBC SQL data type or a driver-specific SQL data type. For a list of valid ODBC SQL data types, see "SQL Data Types" in Appendix D of the ODBC SDK Programmer's Reference. For information about driver-specific SQL data types, see the driver's documentation.

m_nPrecision

The maximum precision of the field. For details, see "Precision, Scale, Length, and Display Size" in Appendix D of the ODBC SDK Programmer's Reference.

m_nScale

The scale of the field. For details, see "Precision, Scale, Length, and Display Size" in Appendix D of the ODBC SDK Programmer's Reference.

m_nNullability

Whether the field accepts a Null value. This can be one of two values: SQL_NULLABLE if the field accepts Null values, or SQL_NO_NULLS if the field does not accept Null values.

See Also   CRecordset::GetODBCFieldInfo, CRecordset::GetFieldValue