ACCESS select SUM(Count) AS MYSUM from Base where WareCode=XXX int sum=recordset->FieldByName("MYSUM")->intValuesSQL SERVER select SUM(Count) MYSUM from Base where WareCode=XXX int sum=recordset->FieldByName("MYSUM")->intValues
列的序号也可以的这个SQL就是列1了
select SUM(Count) as s from Base where WareCode=XXX你直接访问字段s就可以了
select SUM(Count) AS MYSUM from Base where WareCode=XXX
int sum=recordset->FieldByName("MYSUM")->intValuesSQL SERVER
select SUM(Count) MYSUM from Base where WareCode=XXX
int sum=recordset->FieldByName("MYSUM")->intValues