1,178
社区成员
发帖
与我相关
我的任务
分享
String sqlstr;
strMht = pMht;
strMht = StringReplace(strMht, "'", "''",TReplaceFlags()<<rfReplaceAll);
sqlstr.sprintf("insert into carinfo values ('%s','%s','%s','%s','%s','%s','%s',%d)", strDB[0],strDB[1],strDB[2],strDB[3],strDB[4],pCsv,pMht,0);
ADOQuery1->ParamCheck = false;
ADOQuery1->Close();
ADOQuery1->SQL->Clear();
ADOQuery1->SQL->Add(sqlstr);
ADOQuery1->ExecSQL();
String sqlstr;
sqlstr.sprintf("insert into carinfo values ('%s','%s','%s','%s','%s',:pCsv,:pMht,%d)", strDB[0],strDB[1],strDB[2],strDB[3],strDB[4], 0);
ADOQuery1->Close();
ADOQuery1->SQL->Add(sqlstr);
ADOQuery1->Parameters->ParamValues["pCsv"] = pCsv;
ADOQuery1->Parameters->ParamValues["pMht"] = pMht;
ADOQuery1->ExecSQL();
String sqlstr;
sqlstr = "insert into carinfo(Product,Area,CarType,Version,Caption,csv,mht,bookmark) values (:1,:2,:3,:4,:5,:6,:7,:8)";
ADOQuery1->Close();
ADOQuery1->SQL->Clear();
ADOQuery1->SQL->Add(sqlstr);
ADOQuery1->Parameters->ParamByName("1")->Value = strDB[0];
ADOQuery1->Parameters->ParamByName("2")->Value = strDB[1];
ADOQuery1->Parameters->ParamByName("3")->Value = strDB[2];
ADOQuery1->Parameters->ParamByName("4")->Value = strDB[3];
ADOQuery1->Parameters->ParamByName("5")->Value = strDB[4];
ADOQuery1->Parameters->ParamByName("6")->Value = pCsv;
ADOQuery1->Parameters->ParamByName("7")->Value = pMht;
ADOQuery1->Parameters->ParamByName("8")->Value = 0;
ADOQuery1->ExecSQL();