Hi all
I have a little problem wich you guys might be able to help med with
Code:
void CDeploymentDlg::OnOK()
{
CString str;
CDatabase db;
try
{
db.OpenEx("Drive={Microsoft Access Driver(deployment.mdb)};DBQ=deployment.mdb");
//db.OpenEx("Driver = {Microsoft Access Driver(deployment.mdb)};DBQ=deployment.mdb");
//db.OpenEx("deployment.mdb");
//db.OpenEx("deployment.mdb", CDatabase::noOdbcDialog );
//db.OpenEx("Driver={Microsoft Access Driver (deployment.mdb)};DBQ=deployment.mdb;", CDatabase::noOdbcDialog);
}
catch(CDBException*)
{
AfxMessageBox("The database deployment.mdb was not found!!!", MB_ICONERROR);
exit(0);
throw;
}
str.Format("UPDATE webcapsdeployment SET Build=%s, Date=%s WHERE Platform = 'SAND'",m_sSandBuild, m_sSandDate);
db.ExecuteSQL(str);
CDialog::OnOK();
}
I get this error in a AfxMessageBox when running the program:
syntax error in UPDATE statement