subject_67068.htm

vc

<p>
序号：67068 发表者：fiction 发表日期：2003-12-29 10:32:20
<br>主题：在数据库中Fields（）有什么功能？
<br>内容：如题
<br><a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p>
<hr size=1>
<blockquote><p>
回复者：林建华 回复日期：2003-12-29 10:38:41
<br>内容：msdn里面有，但是这部分我没有装
<br>
<a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p></blockquote>
<hr size=1>
<blockquote><p>
回复者：浪际天涯 回复日期：2003-12-29 10:45:38
<br>内容：Fields()，MFC中有这样一个函数吗？
<br>
<a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p></blockquote>
<hr size=1>
<blockquote><p>
回复者：fiction 回复日期：2003-12-29 10:50:34
<br>内容：我按了F1出来的好像不是msnd, 出来的文档的标题是：DAO reference.<BR>这是关于数据库的，解释看不明白,如下：<BR>A Fields collection contains all stored Field objects of an Index, QueryDef, Recordset, Relation, or TableDef object.<BR>Remarks<BR><BR>The Fields collections of the Index, QueryDef, Relation, and TableDef objects contain the specifications for the fields those objects represent. The <BR>Fields collection of a Recordset object represents the Field objects in a row of data, or in a record. You use the Field objects in a Recordset object to read and to set values for the fields in the current record of the Recordset object.<BR><BR>To refer to a Field object in a collection by its ordinal number or by its Name property setting, use any of the following syntax forms:<BR><BR>Fields(0)<BR>Fields(&#34;name&#34;)<BR>Fields![name]<BR><BR>With the same syntax forms, you can also refer to the Value property of a Field object that you create and append to a Fields collection. The context of the field reference will determine whether you are referring to the Field object or the Value property of the Field object.
<br>
<a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p></blockquote>
<hr size=1>
<blockquote><p>
回复者：浪际天涯 回复日期：2003-12-29 11:26:15
<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>
回复者：fiction 回复日期：2003-12-29 11:39:35
<br>内容：Sector_Number = 0<BR>&nbsp;&nbsp;&nbsp;&nbsp;For i = 0 To 127 '&lt;================sector max define<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;If myRs.Fields(i + 5).Value = &#34;NULL&#34; Then<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Sector(i) = &#34;&#34;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Else<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Sector(i) = myRs.Fields(i + 5).Value<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Sector_Number = Sector_Number + 1<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;End If<BR>&nbsp;&nbsp;&nbsp;&nbsp;Next i<BR>这是一串vb的代码,我就是不知道里面那个Field()有什么用
<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>回复者：浪际天涯 回复日期：2003-12-29 12:05:02
<br>内容：myRs.Fields(n);<BR>应该表示的是当前记录的第n个字段的值
<br>
<a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p></blockquote>
<hr size=1>
<blockquote><p>
回复者：fiction 回复日期：2003-12-29 12:20:14
<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>
回复者：徐相华 回复日期：2003-12-29 12:57:20
<br>内容：你还是用myRs.Fields(&#34;fieldname&#34;).value吧，如果别人要维护这个表（重新设计表）时，你的代码不就是完了吗？
<br>
<a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p></blockquote>
<hr size=1>
<blockquote><p>
回复者：fiction 回复日期：2003-12-29 13:57:07
<br>内容：这不是我写的程序，我只是要看懂而已，不过你说得很有道理，让我突然明白了很多。谢谢哦
<br>
<a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p></blockquote>