Question

给Access数据库添加数据，但是提示insert into语法错误

这是我拿messegebox打出来insert into语句的信息
这是提示的错误信息。
源码是hr=m_pConnection->Open(("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\\rtxclentsdk20111formal.exe安装\\Database2.mdb"),"","",adModeUnknown); MessageBox( "insert into Database2(Theme,Content,Time,TiXing,ZhouYi,ZhouEr,ZhouSan,ZhouSi,ZhouWu,ZhouLiu,ZhouRi) values('"+m_EDIT1+"','"+m_NeiRong+"','"+Dingshi+"','"+Lcheck1+"','"+LZhouYi+"','"+LZhouEr+"','"+LZhouSan+"','"+LZhouSi+"','"+LZhouWu+"','"+LZhouLiu+"','"+LZhouRi+"')", "Info", MB_OK ); m_pConnection->Execute(_bstr_t("insert into Database2(Theme,Content,Time,TiXing,ZhouYi,ZhouEr,ZhouSan,ZhouSi,ZhouWu,ZhouLiu,ZhouRi) values('"+m_EDIT1+"','"+m_NeiRong+"','"+Dingshi+"','"+Lcheck1+"','"+LZhouYi+"','"+LZhouEr+"','"+LZhouSan+"','"+LZhouSi+"','"+LZhouWu+"','"+LZhouLiu+"','"+LZhouRi+"')"),NULL ,adCmdText);

哪位大神给看一下，先谢了。





Answer 1

都说了是语法的错误了，那就检查语法啊。

Answer 2

各个字段名都要打引号的