怎么通过ODBC获得ACCESS表设计视图常规中定义的字段大小的属性的值？
如何通过ODBC获得ACCESS表设计视图常规中定义的字段大小的属性的值？？？
CDataRowset m_dataRowset; // 基类CRecordset
CODBCFieldInfo m_odbcFieldInfo;
.....
m_dataRowset.GetODBCFieldInfo( i, m_odbcFieldInfo );
m_odbcFieldInfo中好象没有字段大小属性的值!!!
------解决方案--------------------
struct CODBCFieldInfo
{
CString m_strName;
SWORD m_nSQLType;
UDWORD m_nPrecision;
SWORD m_nScale;
SWORD m_nNullability;
};
Parameters
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 the Platform SDK. 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 the Platform SDK.
m_nScale
The scale of the field. For details, see "Precision, Scale, Length, and Display Size " in the Platform SDK.
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.
CDataRowset m_dataRowset; // 基类CRecordset
CODBCFieldInfo m_odbcFieldInfo;
.....
m_dataRowset.GetODBCFieldInfo( i, m_odbcFieldInfo );
m_odbcFieldInfo中好象没有字段大小属性的值!!!
------解决方案--------------------
struct CODBCFieldInfo
{
CString m_strName;
SWORD m_nSQLType;
UDWORD m_nPrecision;
SWORD m_nScale;
SWORD m_nNullability;
};
Parameters
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 the Platform SDK. 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 the Platform SDK.
m_nScale
The scale of the field. For details, see "Precision, Scale, Length, and Display Size " in the Platform SDK.
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.