Win7+VS2005
实例:
CDatabase db;
bool b = db.Open("SysLog");//假定数据源已经建立
CRecordset rs(&db);
b = rs.Open(CRecordset::forwardOnly,"select * from \"EventLog\" " );//成功
CStringA str;
rs.GetFieldValue((short)0,str);
rs.Close();
db.Close();
注意:
CDatabase db;
bool b = db.Open("SysLog");//假定数据源已经建立
CRecordset rs(&db);
//b = rs.Open(AFX_DB_USE_DEFAULT_TYPE,"select * from \"EventLog\" " );//异常
b = rs.Open(CRecordset::forwardOnly,"select * from \"EventLog\" " );//成功
//b = rs.Open(CRecordset::forwardOnly," select * from \"EventLog\" " );//报错
rs.Close();
db.Close();