subject_14098.htm

一些关于vc的问答

<p>
序号：14098 发表者：wwww 发表日期：2002-09-03 17:31:54
<br>主题：我在编DAO数据库是，在排序问题上出了问题
<br>内容：<BR>我在编DAO数据库是，在排序问题上出了问题<BR><BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;CDaoTableDef* pCnetTableDef＝NULL;<BR>&nbsp;&nbsp;&nbsp;&nbsp;CDaoRecordset* pCnetRecordset＝NULL;<BR>……………………<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pTableDef=new CDaoTableDef(pDatabase);<BR>&nbsp;&nbsp;&nbsp;&nbsp;pRecordset=new CDaoRecordset(pDatabase);<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pTableDef-&gt;Open(_T("Table"));//打开数据表<BR>&nbsp;&nbsp;&nbsp;&nbsp;pRecordset-&gt;Open(pTableDef,dbOpenTable,0);//打开表型记录集<BR>&nbsp;&nbsp;&nbsp;&nbsp;CDaoFieldInfo fieldInfo;<BR>&nbsp;&nbsp;&nbsp;&nbsp;pRecordset-&gt;GetFieldInfo(0,fieldInfo);<BR>&nbsp;&nbsp;&nbsp;&nbsp;pRecordset-&gt;m_strSort=fieldInfo.m_strName+"ASC";<BR>&nbsp;&nbsp;&nbsp;&nbsp;pRecordset-&gt;Requery();<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;………………<BR>编译能通过，为什么运行时候，会出现错，错误就出在pRecordset-&gt;Requery()一句上，但不加这车就不能排序，究竟错在哪里？
<br><a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p>
<hr size=1>
<blockquote><p>
回复者：wenyu 回复日期：2002-09-03 18:37:36
<br>内容：你应在打开记录集之前对m_strSort赋值。
<br>
<a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p></blockquote>
<hr size=1>
<blockquote><p>
回复者：wwww 回复日期：2002-09-04 09:33:56
<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>
<font color=red>答案被接受</font><br>回复者：长老 回复日期：2002-09-05 10:09:01
<br>内容：如下：<BR>&nbsp;&nbsp;&nbsp;&nbsp;CDaoTableDef* pCnetTableDef＝NULL;<BR>&nbsp;&nbsp;&nbsp;&nbsp;CDaoRecordset* pCnetRecordset＝NULL;<BR>&nbsp;&nbsp;&nbsp;&nbsp;pTableDef=new CDaoTableDef(pDatabase);<BR>&nbsp;&nbsp;&nbsp;&nbsp;pRecordset=new CDaoRecordset(pDatabase);<BR>&nbsp;&nbsp;&nbsp;&nbsp;pTableDef-&gt;Open(_T("Table"));//打开数据表<BR>&nbsp;&nbsp;&nbsp;&nbsp;CDaoFieldInfo fieldInfo;<BR>&nbsp;&nbsp;&nbsp;&nbsp;pRecordset-&gt;GetFieldInfo(0,fieldInfo);<BR>&nbsp;&nbsp;&nbsp;&nbsp;pRecordset-&gt;m_strSort=fieldInfo.m_strName+"ASC";<BR>&nbsp;&nbsp;&nbsp;&nbsp;pRecordset-&gt;Open(pTableDef,dbOpenTable,0);<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<br>
<a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p></blockquote>