一个数据检索的小问题(郁闷)
我用的数据库是SQLSERVER2000
连接方式:ADO
select distinct sdmc,shxx,sum(scrs) as sum_rs from ck_jbxx where xl = '2' and shxx = '0' group by shxx,sdmc order by sdmc,shxx
我的这条语句载查询分析器中执行没问题,可是在程序中却通不过
m_Sql = "select distinct SDMC,SHXX,sum(SCRS) as sum_rs from CK_JBXX where XL = '"+m_strXl+"' and shxx = '0' group by SHXX,SDMC order by SDMC,SHXX" ;
m_pRecordset->Open((_variant_t)m_Sql,_variant_t(theApp.m_pConnection.GetInterfacePtr(),true),adOpenStatic,adLockOptimistic,adCmdText);
回事什么问题,请大家指教