📄 index110.htm
字号:
<html>
<style type="text/css"><!--
.p9 { font-family: "宋体"; font-size: 9pt}a {text-transform: none; text-decoration: none;}
a:hover {text-decoration: underline; color: #FF0000;}
--></style>
<body background="../di2001.jpg">
<h3 align="center"><font COLOR="#AOAO99"></font></h3>
<table width="100%" border="1" cellspacing="1">
<tr><td><p align="center"><font color="#FF0000">从数据库中读大于32k的内容?</font></td></tr>
<tr><td><p>
</Br>
我在从数据库中读数据时碰到了问题.当数据栏包含超过32k的内容时,我就读不出来,我试过ODBC::SQLGetData()也不行.<Br>
</Br>
哪种类型的数据库?MS SQL,SYBASE... 试试设置一下大小:<Br>
BOOL CGetBlobStmt::Execute(LPCTSTR stmt)<Br>
{<Br>
m_cbSize = 0;<Br>
m_size = 0;<Br>
LPBYTE<Br>
lpData;<Br>
lpData = (LPBYTE)GlobalLock(m_hData);<Br>
</Br>
m_retcode = SQLSetStmtOption(GetHandle(),SQL_MAX_LENGTH,m_dwBytesLeft);<Br>
</Br>
m_retcode = SQLExecDirect(GetHandle(),(UCHAR*)stmt,SQL_NTS);<Br>
if (m_retcode == SQL_SUCCESS)<Br>
{<Br>
m_retcode = SQLFetch(GetHandle());<Br>
if (m_retcode == SQL_SUCCESS ||m_retcode == SQL_SUCCESS_WITH_INFO)<Br>
{<Br>
m_retcode = SQLGetData(GetHandle(),1,SQL_C_BINARY,lpData,254,&m_cbSize);<Br>
while(m_retcode == SQL_SUCCESS_WITH_INFO)<Br>
{<Br>
lpData+= 254;<Br>
m_retcode = SQLGetData(GetHandle(),1,SQL_C_BINARY,lpData,254,&m_cbSize);<Br>
}<Br>
GetError();<Br>
}<Br>
}<Br>
GlobalUnlock(m_hData);<Br>
#if TESTDATA<Br>
TRACE("%ld",m_size);<Br>
#endif<Br>
</Br>
SaveFile();<Br>
</Br>
return RETVALUE;<Br>
}<Br>
</Br>
</p></td></tr>
</table>
</body></html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -