strSQL.Format("Select LRRQ,NRMS,JHKSRQ & \" \" & JHKSSJ As JHKS,JHWCRQ & \" \" & JHWCSJ As JHWC,TX,LB,JB From T_NOTE Where LRRQ >= #%s#",startDate);
nVal = m_pRecordset -> GetState();
if(nVal == 1) m_pRecordset->Close();
m_pRecordset -> Open(strSQL.GetBuffer(strSQL.GetLength()),
theApp.m_pConnection.GetInterfacePtr(), // 获取库接库的IDispatch指针
adOpenDynamic,
adLockOptimistic,
adCmdText);
nVal = m_pRecordset -> GetState();
if(nVal == 1) m_pRecordset->Close();
m_pRecordset -> Open(strSQL.GetBuffer(strSQL.GetLength()),
theApp.m_pConnection.GetInterfacePtr(), // 获取库接库的IDispatch指针
adOpenDynamic,
adLockOptimistic,
adCmdText);
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货