#include "sql.h"
#include "Windows.h"
in OnRead() function
SQLRETURN rc;
CDatabase database;
CString strName,SqlString;
CString sCatID, sCategory,Username;
CString sDriver = "MICROSOFT ACCESS DRIVER (*.mdb)";
CString sDsn;
CString sFile = "E:\\Truck.mdb";
int iRec = 0;
sDsn.Format("ODBC;DRIVER={%s};DSN='';DBQ=%s",sDriver,sFile);
TRY
{
database.Open(NULL,false,false,sDsn);
rc = SQLAllocEnv(database);
SqlString = "SELECT * FROM Trucklogin";
rc=SQLExecute("SELECT * from Trucklogin");
AfxMessageBox(rc);
recset.Open(CRecordset::forwardOnly,SqlString,CRecordset::readOnly);
CATCH(CDBException, e)
{
AfxMessageBox("Database error: "+e->m_strError);
}
END_CATCH;
how to find whether the values are accessing fron table or not??
please help me with some code.