📄 7411.html

📁 VB技巧问答10000例 VB技巧问答10000例

💻 HTML

字号:

<html>
  <head>
    <title>Re: 限定资料量!!救人喔!</title>
  </head>
  <body bgcolor="#FFFFFF" vlink="#808080">
    <center>
      <h1>Re: 限定资料量!!救人喔!</h1>
    </center>
<hr size=7 width=75%>

<hr size=7 width=75%><p>
Posted by Miki on November 17, 1998 at 15:56:50:<p>
In Reply to: <a href="7392.html">限定资料量!!救人喔!</a> posted by Gary Chen on November 16, 1998 at 20:31:32:<p>
: 请问在RDO中该如何设定才能有像在RDC中使用MaxRows一样的功能`<br>: 救命一下!<br>: 因为我现在有一次读出太多资料而中断ODBC的状况<br>: 万般感谢!<p><br>    Set ResultRS = rdoCN.OpenResultset(SQL_String, rdOpenForwardOnly, rdConcurReadOnly, rdAsyncEnable)<p><br>    ColCnt = ResultRS.rdoColumns.Count<p>    Do While ResultRS.EOF = False<br>       RS_Array = ResultRS.GetRows(1000) '一次取回1000笔资料<br>       RowsReturned = UBound(RS_Array, 2) + 1 '取得阵列中所有的笔数<br>       For II = 1 To RowsReturned<br>         For j = 1 To ColCnt - 1<br>             itemstring = itemstring & RS_Array(j - 1, II - 1) & vbTab<br>         Next j<br>         itemstring = itemstring & RS_Array(ColCnt - 1, II - 1)<br>         MSFlexGrid1.AddItem "" & vbTab & itemstring<br>         itemstring = ""<br>         If CancelRS = True Then<br>            ResultRS.Cancel<br>            Exit Do<br>         End If<br>         DoEvents<br>       Next II<br>    Loop<br>
<br>
<br><hr size=7 width=75%><p>
<a name="followups">Follow Ups:</a><br>
<ul><!--insert: 7411-->
</ul><!--end: 7411-->
<br><hr size=7 width=75%><p>

</body></html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -