向数据库里添加字段:
sql_.Format("SELECT* FROM STUDENT WHERE CODE ISNULL");
_bstr_t sql=sql_;
_variant_t vNull;
vNull.vt=VT_ERROR;
vNull.scode=DISP_E_PARAMNOTFOUND;
try
{
hr=pRset.CreateInstance(__uuidof(Recordset));
if(SUCCEEDED(hr))
{
pRset->PutRefActiveConnection(pConn);
hr=pRset->Open(_variant_t(sql),vNull,adOpenKeyset,adLockOptimistic,adCmdText);
if(SUCCEEDED(hr))
{
COleSafeArray vaFieldlist;
vaFieldlist.CreateOneDim(VT_VARIANT,3);
long lArrayIndex[1];
lArrayIndex[0]=0;
vaFieldlist.PutElement(lArrayIndex,&(_bstr_t("name")));
lArrayIndex[0]=1;
vaFieldlist.PutElement(lArrayIndex,&(_bstr_t("code")));
lArrayIndex[0]=2;
vaFieldlist.PutElement(lArrayIndex,&(_bstr_t("telno")));
COleSafeArray vaValuelist;
lArrayIndex[0]=0;
vaValuelist.PutElement(lArrayIndex,&(_variant_t("m_name")));
lArrayIndex[0]=1;
vaValuelist.PutElement(lArrayIndex,&(_variant_t("m_code")));
lArrayIndex[0]=2;
vaValuelist.PutElement(lArrayIndex,&(_variant_t("m_telno")));
pRset->AddNew(vaFieldlist,vaValuelist);
pRset->Update(); //m_name,m_code,m_telno为编辑框变量,为CString类型;
RefreshData();//刷新list Control 里的内容。
pRset->Close();
}
else{AfxMessageBox("失败1");}
}
else{AfxMessageBox("失败2");}}
catch(_com_error&e)
{
AfxMessageBox(e.ErrorMessage());
}运行后,提示错误信息:IDispatch error #3092
msdn 里的解释为:There is no account for this computer in the security database.
请问这怎么解决。
sql_.Format("SELECT* FROM STUDENT WHERE CODE ISNULL");
_bstr_t sql=sql_;
_variant_t vNull;
vNull.vt=VT_ERROR;
vNull.scode=DISP_E_PARAMNOTFOUND;
try
{
hr=pRset.CreateInstance(__uuidof(Recordset));
if(SUCCEEDED(hr))
{
pRset->PutRefActiveConnection(pConn);
hr=pRset->Open(_variant_t(sql),vNull,adOpenKeyset,adLockOptimistic,adCmdText);
if(SUCCEEDED(hr))
{
COleSafeArray vaFieldlist;
vaFieldlist.CreateOneDim(VT_VARIANT,3);
long lArrayIndex[1];
lArrayIndex[0]=0;
vaFieldlist.PutElement(lArrayIndex,&(_bstr_t("name")));
lArrayIndex[0]=1;
vaFieldlist.PutElement(lArrayIndex,&(_bstr_t("code")));
lArrayIndex[0]=2;
vaFieldlist.PutElement(lArrayIndex,&(_bstr_t("telno")));
COleSafeArray vaValuelist;
lArrayIndex[0]=0;
vaValuelist.PutElement(lArrayIndex,&(_variant_t("m_name")));
lArrayIndex[0]=1;
vaValuelist.PutElement(lArrayIndex,&(_variant_t("m_code")));
lArrayIndex[0]=2;
vaValuelist.PutElement(lArrayIndex,&(_variant_t("m_telno")));
pRset->AddNew(vaFieldlist,vaValuelist);
pRset->Update(); //m_name,m_code,m_telno为编辑框变量,为CString类型;
RefreshData();//刷新list Control 里的内容。
pRset->Close();
}
else{AfxMessageBox("失败1");}
}
else{AfxMessageBox("失败2");}}
catch(_com_error&e)
{
AfxMessageBox(e.ErrorMessage());
}运行后,提示错误信息:IDispatch error #3092
msdn 里的解释为:There is no account for this computer in the security database.
请问这怎么解决。
解决方案 »
- [求助]我的SCROLL不自动滚向最后一行。
- 加载资源后,为何GetLastError()后出现1812错误?
- 界面问题!!急
- 请问STL 中的vector的用法 我在定义 vector<int> temp; 时编译出错我已经包含了<vector>
- link error 2001:unresolved external symbol 是由什麽引起的啊?
- 搞不懂,为什么我的UpdateData(FALSE)就是不好用?在线等待。。。。。。
- the problem of combo box?
- vc中如何读到txt文件中各行,然后存到字符串数组中?
- 自学C++,遇难题,望给点启示!!
- CString的使用出错问题
- -------送分--------,请问,在XP下有没有类似于PVIEW95的工具。那里可以下载得到。
- 傻瓜问题
用下面的试试。
SELECT * FROM [STUDENT$A1:IV65536]
There is no account for this computer in the security database.