subject_14096.htm

一些关于vc的问答

<p>
序号：14096 发表者：wwww 发表日期：2002-09-03 17:29:07
<br>主题：我在编DAO数据库是，在排序问题上出了了问题
<br>内容：<BR>我在编DAO数据库是，在排序问题上出了了问题<BR><BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;CDaoTableDef* pCnetTableDef＝NULL;<BR>&nbsp;&nbsp;&nbsp;&nbsp;CDaoRecordset* pCnetRecordset＝NULL;<BR>……………………&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>
回复者：东方红 回复日期：2002-09-04 12:52:38
<br>内容：打开记录集时用SQL文排序，而不是直接打开表。<BR>比如：<BR>Open(_T("SELECT * FROM TABLE ORDER BY NAME"));<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>
<font color=red>答案被接受</font><br>回复者：长老 回复日期：2002-09-05 10:07:43
<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>