当前位置：网站首页>Use cricordset directly without using the derived classes of cricordset

Use cricordset directly without using the derived classes of cricordset

2022-07-22 02:58:00 【51CTO】


 Win7+VS2005

 

example ：

CDatabase db;
 bool b = db.Open("SysLog");// Assume that the data source has been established 

      
      

       
       CRecordset rs(&db); 
       
       
  b = rs.Open(CRecordset::forwardOnly,"select * from \"EventLog\" " );// success 
       
       
  CStringA str;
       
       
  rs.GetFieldValue((short)0,str);
       
       
  rs.Close();
       
       
  db.Close();
      
      

      
      
    
       
       
  • 1.
    • 
       
       
  • 2.
    • 
       
       
  • 3.
    • 
       
       
  • 4.
    • 
       
       
  • 5.
    • 
       
       
  • 6.
    •

 

Be careful ：

CDatabase db;
 bool b = db.Open("SysLog");// Assume that the data source has been established 

      
      

       
       CRecordset rs(&db);
       
       
  //b = rs.Open(AFX_DB_USE_DEFAULT_TYPE,"select * from \"EventLog\" " );// abnormal 
       
       
  b = rs.Open(CRecordset::forwardOnly,"select * from \"EventLog\" " );// success 
       
       
  //b = rs.Open(CRecordset::forwardOnly," select * from \"EventLog\" " );// Report errors 
       
       
  rs.Close();
       
       
  db.Close();
      
      

      
      
    
       
       
  • 1.
    • 
       
       
  • 2.
    • 
       
       
  • 3.
    • 
       
       
  • 4.
    • 
       
       
  • 5.
    • 
       
       
  • 6.
    •
原网站

版权声明
本文为[51CTO]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/203/202207211009599031.html

边栏推荐

猜你喜欢

随机推荐