排序没问题了,但如何查询某一时间段内的记录呢?我如下作,总是报错:参数不足,期待是2; rs.Open(CRecordset::dynaset,_T("select * from MyRecord where FaultTime > StartTime and FaultTime < EndTime ")); 请问是什么原因?
CString Sql; Sql.Format("select * from MyRecord where FaultTime > '%s' and FaultTime < '%s'", StartTime, StartTime); rs.Open(CRecordset::dynaset, Sql);
rs.Open(CRecordset::dynaset,_T("select * from MyRecord where FaultTime > StartTime and FaultTime < EndTime "));
请问是什么原因?
CString Sql;
Sql.Format("select * from MyRecord where FaultTime > '%s' and FaultTime < '%s'", StartTime, StartTime);
rs.Open(CRecordset::dynaset, Sql);