subject_64111.htm

vc

<p>
序号：64111 发表者：okvc 发表日期：2003-12-08 21:29:01
<br>主题：GetRecordCount();IsEOF()都不正常，为什么？
<br>内容：如下代码，GetRecordCount()返回值为1；<BR>while(pSet-&gt;IsEOF())的循环一直进不去，这两个函数好像有问题呀！！！<BR>哪位大侠知道的解释解释。<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;CDatabase db;<BR>&nbsp;&nbsp;&nbsp;&nbsp;int i;<BR>&nbsp;&nbsp;&nbsp;&nbsp;db.Open(&#34;ODBC;DSN=qq&#34;, FALSE, FALSE&nbsp;&nbsp;);<BR>&nbsp;&nbsp;&nbsp;&nbsp;CString m_str,aaa;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;m_str.Format(&#34;Select * From [dbo].[new]&#34;);<BR>&nbsp;&nbsp;&nbsp;&nbsp;CSqlSet * pSet;<BR>&nbsp;&nbsp;&nbsp;&nbsp;pSet=new CSqlSet(&amp;db);<BR>&nbsp;&nbsp;&nbsp;&nbsp;pSet-&gt;Open(CRecordset::snapshot,m_str,0 );//<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; i=pSet-&gt;GetRecordCount();&nbsp;&nbsp;&nbsp;&nbsp;<BR>&nbsp;&nbsp;&nbsp;&nbsp;pSet-&gt;MoveFirst();<BR>&nbsp;&nbsp;&nbsp;&nbsp;while(pSet-&gt;IsEOF())<BR>&nbsp;&nbsp;&nbsp;&nbsp;{<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;pSet-&gt;MoveNext();<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;i++;<BR>&nbsp;&nbsp;&nbsp;&nbsp;}<BR>&nbsp;&nbsp;&nbsp;&nbsp;
<br><a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p>
<hr size=1>
<blockquote><p>
<font color=red>答案被接受</font><br>回复者：dstwwx 回复日期：2003-12-08 21:45:58
<br>内容：1.<BR>http://www.vchelp.net/cndevforum/subject_view.asp?subject_id=62781<BR><BR>2.<BR>while(pSet-&gt;IsEOF())<BR>应该是<BR>while(!pSet-&gt;IsEOF())<BR><BR><BR>前面pSet-&gt;MoveFirst();<BR>后面while(pSet-&gt;IsEOF())<BR>应该不会进入的<BR><BR><BR><BR>
<br>
<a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p></blockquote>
<hr size=1>
<blockquote><p>
回复者：okvc 回复日期：2003-12-08 21:51:20
<br>内容：谢谢！
<br>
<a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p></blockquote>