CDatabase* m_database;
CXXXRecordSet* m_pSet; m_pSet=new CXXXRecordSet(m_database);
CString str ="select sum(MONEY) as vsum from XXX";
m_database->ExecuteSQL(str);这样能否获取 MONEY列的和?如果可以又该如何把 vsum里的值取出来?谢谢大家!
CXXXRecordSet* m_pSet; m_pSet=new CXXXRecordSet(m_database);
CString str ="select sum(MONEY) as vsum from XXX";
m_database->ExecuteSQL(str);这样能否获取 MONEY列的和?如果可以又该如何把 vsum里的值取出来?谢谢大家!
CRecordset Overview | Class Members | Hierarchy Chart | CRecordset::DoFieldExchange | CRecordset::DoBulkFieldExchange | CRecordset::GetODBCFieldCount | CRecordset::GetODBCFieldInfo | CRecordset::SetRowsetCursorPosition
Retrieves field data in the current record.void GetFieldValue(
LPCTSTR lpszName,
CDBVariant& varValue,
short nFieldType = DEFAULT_FIELD_TYPE
);
void GetFieldValue(
short nIndex,
CDBVariant& varValue,
short nFieldType = DEFAULT_FIELD_TYPE
);
void GetFieldValue(
short nIndex,
CStringA& strValue
);
void GetFieldValue(
short nIndex,
CStringW& strValue
);
// do not load the cursor library
CDatabase db;
db.OpenEx( NULL, CDatabase::forceOdbcDialog );// Create and open a recordset object
// directly from CRecordset. Note that a
// table must exist in a connected database.
// Use forwardOnly type recordset for best
// performance, since only MoveNext is required
CRecordset rs( &db );
rs.Open( CRecordset::forwardOnly,
_T( "SELECT * FROM SomeTable" ) );// Create a CDBVariant object to
// store field data
CDBVariant varValue;// Loop through the recordset,
// using GetFieldValue and
// GetODBCFieldCount to retrieve
// data in all columns
short nFields = rs.GetODBCFieldCount( );
while( !rs.IsEOF( ) )
{
for( short index = 0; index < nFields; index++ )
{
rs.GetFieldValue( index, varValue );
// do something with varValue
}
rs.MoveNext( );
}rs.Close( );
db.Close( );
CDatabase* m_database;
CXXXRecordSet* m_pSet; m_pSet=new CXXXRecordSet(m_database);
CString str ="select sum(MONEY) as vsum from XXX";
m_pSet->Open(CRecordset::dynaset,str); // 这里出来了数据被截断的错误!!怎么回事呢
CString str ="select sum([MONEY]) as vsum from XXX";
取Vsum就是了
货币类型的映射过来的时候是CString类型,怎么解决呢?
比如:select * from [查询1]
试试