Thread: CString.Format

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