4,011
社区成员
发帖
与我相关
我的任务
分享
bool CAccessManager::CreateTimeTable(CString& sOutTime,CString sInFolder)
{
CDaoAccess _Access;
m_sAccessPath = sInFolder;
SYSTEMTIME st;
GetLocalTime(&st);
sOutTime.Format("%d_%d_%d", st.wYear, st.wMonth, st.wDay);
_Access.CreatAccessDB(sInFolder);
CString strSql;
strSql.Format("CREATE TABLE %s(ID AUTOINCREMENT PRIMARY KEY,时间 VARCHAR(200),模板型号 VARCHAR(200),识别结果 VARCHAR(200),图片地址 TEXT)",sOutTime);
//创建表;
_Access.CmdSql(sInFolder,strSql);//CreateAccess(outExcel,sPath);
strSql.Format("ALTER TABLE 2019_2_12 ALTER COLUMN 图片地址 Hyperlink");
//创建表;
_Access.CmdSql(sInFolder, strSql);//CreateAccess(outExcel,sPath);
m_sCurTable = sOutTime;
return true;
}
}