在win200server下deletefile删除文件可以,但在98下使用deletefile 提示拒绝删除, 2000里打开文件的方式和98不一样,98一般用只读打开的时候,别的进程也不能删除,但在2000里,确不影响删除. 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 strSQL.Format("SELECT * FROM nldtemp"); conn.ExecuteSQL((_bstr_t)(LPCTSTR)strSQL); //强行拷贝,存在则覆盖 CopyFile(srcfile,tarfile,FALSE); while (!conn.m_pRecordset->adoEOF) { _variant_t vf1 = conn.m_pRecordset->GetCollect("f1"); CString strf1; strf1.Format("%s",(LPCTSTR)(_bstr_t)vf1); _variant_t vf3 = conn.m_pRecordset->GetCollect("f3"); CString strf3; strf3.Format("%s",(LPCTSTR)(_bstr_t)vf3); _variant_t vf4 = conn.m_pRecordset->GetCollect("f4"); CString strf4; strf4.Format("%s",(LPCTSTR)(_bstr_t)vf4); _variant_t vf7 = conn.m_pRecordset->GetCollect("f7"); CString strf7,tempy,tempm,tempd; strf7.Format("%s",(LPCTSTR)(_bstr_t)vf7); tempy = strf7.Left(strf7.Find("-",0)); strf7 = strf7.Right(strf7.GetLength()-strf7.Find("-",0)-1); tempm = strf7.Left(strf7.Find("-",0)); strf7 = strf7.Right(strf7.GetLength()-strf7.Find("-",0)-1); tempd = strf7; strf7.Format("%s/%s/%s",tempm,tempd,tempy.Right(2)); TRACE("f1 field : %s\n",strf1); TRACE("f3 field : %s\n",strf3); TRACE("f4 field : %s\n",strf4); TRACE("f7 field : %s\n",strf7); CString Sql; Sql.Format("INSERT INTO %s(f1,f2,f3,f4,f5,f6,f7,f8,f9,f10,f11,f12,f13,f14,f15,f16,f17,f18,f19,f20) VALUES('%s','','%s','%s','','',DATE(%s,%s,%s),'',0.00000,'',0.00000,'','','','',0.00000,0.00000,0.00000,'',0.00000)", tempfile,strf1,strf3,strf4,tempy,tempm,tempd); conn.ExecuteSQL((_bstr_t)(LPCTSTR)Sql,FALSE); conn.m_pRecordset->MoveNext(); } conn.m_pConnection->Close(); //CString ldfile; //ldfile.Format("%s\\%s.dbf",path,ldtable); //DeleteFile(ldfile); if(!CopyFile(tarfile,ldfile,FALSE)) { dw=GetLastError(); TRACE("Copy %s to %s Error,the Error code is %d\n",tarfile,ldfile,dw); } if(!DeleteFile(ldtfile)) { dw=GetLastError(); TRACE("Delete %s Error,the Error code is %d",ldtfile,dw); } if(!DeleteFile(tarfile)) { dw=GetLastError(); TRACE("Delete %s Error,the Error code is %d\n",tarfile,dw); } 【求助】做图像分割,求双峰法的C/C++源代码 请解释 形参 int &arr[10]和形参 int (&arr)[10]的含义 用ADO怎么把文件存入ACCESS数据库? ADO下,_RecordsetPtr的status判断报错 有谁了解chrome? 存入CString类型的变量中 传一个CWnd指针到动态连接库,为什么告诉我HWND=??? 如何在自建的视类中获得文档类的指针? 解决这个问题我送200分 网站咋个IP统计的啊? 关于聊天室的大负载问题 如何在VC中用程序代码控制SQLServer2K,如备份数据库等系统管理操作?
conn.ExecuteSQL((_bstr_t)(LPCTSTR)strSQL);
//强行拷贝,存在则覆盖
CopyFile(srcfile,tarfile,FALSE); while (!conn.m_pRecordset->adoEOF)
{
_variant_t vf1 = conn.m_pRecordset->GetCollect("f1");
CString strf1;
strf1.Format("%s",(LPCTSTR)(_bstr_t)vf1);
_variant_t vf3 = conn.m_pRecordset->GetCollect("f3");
CString strf3;
strf3.Format("%s",(LPCTSTR)(_bstr_t)vf3);
_variant_t vf4 = conn.m_pRecordset->GetCollect("f4");
CString strf4;
strf4.Format("%s",(LPCTSTR)(_bstr_t)vf4);
_variant_t vf7 = conn.m_pRecordset->GetCollect("f7");
CString strf7,tempy,tempm,tempd;
strf7.Format("%s",(LPCTSTR)(_bstr_t)vf7);
tempy = strf7.Left(strf7.Find("-",0));
strf7 = strf7.Right(strf7.GetLength()-strf7.Find("-",0)-1);
tempm = strf7.Left(strf7.Find("-",0));
strf7 = strf7.Right(strf7.GetLength()-strf7.Find("-",0)-1);
tempd = strf7;
strf7.Format("%s/%s/%s",tempm,tempd,tempy.Right(2));
TRACE("f1 field : %s\n",strf1);
TRACE("f3 field : %s\n",strf3);
TRACE("f4 field : %s\n",strf4);
TRACE("f7 field : %s\n",strf7); CString Sql;
Sql.Format("INSERT INTO %s(f1,f2,f3,f4,f5,f6,f7,f8,f9,f10,f11,f12,f13,f14,f15,f16,f17,f18,f19,f20) VALUES('%s','','%s','%s','','',DATE(%s,%s,%s),'',0.00000,'',0.00000,'','','','',0.00000,0.00000,0.00000,'',0.00000)",
tempfile,strf1,strf3,strf4,tempy,tempm,tempd);
conn.ExecuteSQL((_bstr_t)(LPCTSTR)Sql,FALSE); conn.m_pRecordset->MoveNext();
}
conn.m_pConnection->Close(); //CString ldfile;
//ldfile.Format("%s\\%s.dbf",path,ldtable);
//DeleteFile(ldfile);
if(!CopyFile(tarfile,ldfile,FALSE))
{
dw=GetLastError();
TRACE("Copy %s to %s Error,the Error code is %d\n",tarfile,ldfile,dw);
}
if(!DeleteFile(ldtfile))
{
dw=GetLastError();
TRACE("Delete %s Error,the Error code is %d",ldtfile,dw);
}
if(!DeleteFile(tarfile))
{
dw=GetLastError();
TRACE("Delete %s Error,the Error code is %d\n",tarfile,dw);
}