How do I open SQL database using DAO??
C / C++ / MFC
2
Posts
2
Posters
0
Views
1
Watching
-
Hiya how do I open an SQL database using DAO?? I know I have to use the member function open of CDAODatabase, but can't get it to work for me.. Thanks, grahamoj.
-
Hiya how do I open an SQL database using DAO?? I know I have to use the member function open of CDAODatabase, but can't get it to work for me.. Thanks, grahamoj.
Here is a simple example. CDaoDatabase db; char requetesql[300]; db.Open(_T("db1.mdb")); CDaoRecordset rs(&db); rs.Open(dbOpenDynaset, _T("SELECT count([Mis1]) AS numMis1 FROM comptes WHERE Mis1=200 and Mis3=200;")); COleVariant varName; //...etc varName= rs.GetFieldValue("numMis1"); rs.Close(); db.Close(); } don't forget to #include . Good luck!