ADO因SQL过长而导致VC卡掉(紧急)
try{
CString strcon = "Provider=OraOLEDB.Oracle.1;Data Source=orcl1;User ID=system;Password=admin;Unicode=True";
CoInitialize(NULL);
m_Con.CreateInstance(__uuidof(Connection));
m_Rst.CreateInstance(__uuidof(Recordset));
m_Rest.CreateInstance(__uuidof(Recordset));
m_Con->CursorLocation = adUseClient;
m_Con->Open((LPCTSTR)strcon,"","",adModeUnknown);
hr = m_Rst->Open("SELECT a.XF_STORECODE,b.XF_PLU,SUM(b.XF_REFQTY),SUM(b.XF_REFAMT),b.XF_COMMRATE,SUM(b.XF_SETTLEAMT),c.XF_CONTRACTDESC FROM XF_BSCONTRACTITEM a,XF_BSSETTLEMEMOD1_EXT b,XF_BSCONTRACTH c where a.XF_STORECODE=b.XF_REFSTORECODE and b.XF_REFSTORECODE=c.XF_STORECODE GROUP BY a.XF_STORECODE,b.XF_PLU,b.XF_COMMRATE,c.XF_CONTRACTDESC",m_Con.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
}
调试的时候 执行到 sql那VC就会卡掉.
还有什么方法能执行呢. 是在不想分开sql语句. 很麻烦呢.