VC 的ODBC CRecordset是不是不支持包含逻辑的SQL语句?
CString m_sql = "select a.name,count(*)+1 from t_CUMBER a inner join t_CUMBER b on a.name=b.name and a.time>b.time where datediff('s',a.time,b.time)<=1 group by a.name";
Ctab_car m_tabRepeat;//check exist repeat data
if(m_tabRepeat.IsOpen())
m_tabRepeat.Close();
if(m_tabRepeat.Open(AFX_DB_USE_DEFAULT_TYPE,m_sql))
{
if(m_tabRepeat.IsEOF()) return 0;
m_tabRepeat.MoveFirst();
//检查...是否存在,
while(!m_tabRepeat.IsEOF())
{
rst++;
m_tabRepeat.MoveNext();
}
//return rst;
}
}
catch (CDBException* e)
{
SetWindowText("查询结果:无法打开车辆数据库");
AfxMessageBox(e->m_strError);
}
//////