_ConnectionPtr m_pConnection;
_RecordsetPtr m_pRecordset;
try
{
m_pConnection.CreateInstance(__uuidof(Connection));
m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Test.MDB","","",adModeUnknown);
}
catch(_com_error e)
{
CString errormessage;
errormessage.Format("conncetion error:%s",e.ErrorMessage());
AfxMessageBox(errormessage);
return;
}
try
{
m_pRecordset.CreateInstance("ADODB.Recordset");
m_pRecordset->Open("SELECT EmployeeID,FirstName,LastName,HireDate,City FROM TEST TABLE WHERE City='London'",
m_pRecordset->Open(_variant_t(sql),
_variant_t((IDispatch*)m_pConnection,true),
adOpenStatic,
adLockOptimistic,
adCmdText);
}
如果 SQL为
SELECT EmployeeID,FirstName,LastName,HireDate,City FROM TESTTABLE WHERE City='London'
就没有问题
但是一旦在把表名字从TESTTABLE ->TEST TABLE, 有空格的表明,那么这个SQL就执行不了了。
请各位大侠,帮忙解决一下。
谢谢!