什么意思? select count(*) as count_1,sum(amt) as sum_1 ,bankid from bank group bankid 执行后,在ODBC里使用函数GetFieldValue( "count_1" , m_Var ); 就可以了吧
cdatabase db; db.open(...); crecordset rs(&db); CDBVariant dd; double d1; long l1; rs.Open(CRecordset::forwardOnly,"select count(*) as count_1,sum(amt) as sum_1 ,bankid from bank group bankid",CRecordset::readOnly); if (!rs.iseof()){ rs.GetFieldValue("count_1",dd,SQL_C_SLONG); if (dd.m_dwType != DBVT_NULL ) l1=dd.m_lVal; } rs.GetFieldValue("sum_1",dd,SQL_C_DOUBLE); if (dd.m_dwType != DBVT_NULL ) d1=dd.m_dblVal; } rs.close();
select count(*) as count_1,sum(amt) as sum_1 ,bankid from bank group bankid
执行后,在ODBC里使用函数GetFieldValue( "count_1" , m_Var );
就可以了吧
db.open(...);
crecordset rs(&db);
CDBVariant dd;
double d1;
long l1;
rs.Open(CRecordset::forwardOnly,"select count(*) as count_1,sum(amt) as sum_1 ,bankid from bank group bankid",CRecordset::readOnly);
if (!rs.iseof()){
rs.GetFieldValue("count_1",dd,SQL_C_SLONG);
if (dd.m_dwType != DBVT_NULL )
l1=dd.m_lVal; }
rs.GetFieldValue("sum_1",dd,SQL_C_DOUBLE);
if (dd.m_dwType != DBVT_NULL )
d1=dd.m_dblVal;
}
rs.close();