VC+ADO+ACCESS数据库开发中,程序代码如下:
strSql = _T("CREATE TABLE DuiInfo (DuiInfoID int, CaiFaZhengHao int,TongZhiInfo int,CheNum nvarchar(8),Time smalldatetime,CaiJiSum float,MuTouSum int,Photo IMAGE)");
//strSql = _T("CREATE TABLE MuTouType2 (MuTouID INT, MuTouName NVARCHAR(5))");
bstrSQL = strSql.AllocSysString();
m_pConnection->Execute(bstrSQL, &RecordsAffected, adCmdText);
用strSql = _T("CREATE TABLE MuTouType2 (MuTouID INT, MuTouName NVARCHAR(5))")语句
调用m_pConnection->Execute()函数出现没问题。
用strSql = _T("CREATE TABLE DuiInfo (DuiInfoID int, CaiFaZhengHao int,TongZhiInfo int,CheNum nvarchar(8),Time smalldatetime,CaiJiSum float,MuTouSum int,Photo IMAGE)");
m_pConnection->Execute()函数出现出问题。
请问若想建立一个表格,表格中包含DuiInfoID(int),CaiFaZhengHao (int),tongzhiInfo(int),CheNum(unicode字符串),Time(时间)CaiJiSum(float),MutouNum(int),Photo(图像)对应access的sql语句该如何写呢?
"CREATE TABLE DuiInfo (DuiInfoID int, CaiFaZhengHao int,TongZhiInfo int,CheNum nvarchar(8),[Time] date,CaiJiSum float,MuTouSum int,Photo IMAGE)"
TIME 是关键字,加上[]