INSERT INTO 语法错误,急,在线等
CDaoDatabase daoDB;
daoDB.Open("CBERS-02B_2008_19.5_1997.mdb");
CString strCommand="INSERT INTO 2008_195 (Area,Path,Row,SN,Date,Info) VALUES (";
strCommand+="'";
strCommand+=strArea;
strCommand+="'";
strCommand+=",";
strCommand+=strPath;
strCommand+=",";
strCommand+=strRow;
strCommand+=",";
strCommand+=strSN;
strCommand+=",";
strCommand+=strDate;
strCommand+=",";
strCommand+="'";
strCommand+=strInfo;
strCommand+="'";
strCommand+=")";
MessageBox(strCommand);
daoDB.Execute(strCommand);
daoDB.Close();
各位大虾,以上我程序中的一段连接代码,调试时老是报错,说INSERT INTO statement语法错误。忙活了半天也没有调试成功,发上来希望有手支招。先行谢过大虾们了。。。
ps:里面的area和info是文本型,其他字段是数值型。