16353.html

来自「以电子书的形式收集了VB一些常见问题解决方法,可以很方便的查找自己需要解决的问题」· HTML 代码 · 共 23 行

HTML
23
字号
<html>
  <head>
    <title>Re: 请问在VB6下,如何开启 index 。(急)</title>
  </head>
  <body bgcolor="#FFFFFF" vlink="#808080">
    <center>
      <h1>Re: 请问在VB6下,如何开启 index 。(急)</h1>
    </center>
<hr size=7 width=75%>

<hr size=7 width=75%><p>
Posted by <a href="mailto:Luo570@ms31.hinet.net">小琳小姐</a> on July 29, 1999 at 11:56:38:<p>
In Reply to: <a href="16321.html">Re: 请问在VB6下,如何开启 index 。(急)</a> posted by 小琳 on July 28, 1999 at 20:52:02:<p>
小琳小姐,您好!<br>首先谢谢您的回应。我的程式如下:<br>在VB6下的程式码是:<p>'以下用来开启 PEOPLE.mdb 之设定<br>Dim pplConn As New ADODB.Connection<br>Dim pplRS As New ADODB.Recordset<p>'以上用来开启 eMbox.mdb 之设定<br>Dim eMConn As New ADODB.Connection<br>Dim eMrseMBox As New ADODB.Recordset<br>Dim eMrsCounter As New ADODB.Recordset<p>Private Sub Form_Load()<br>'以下是 people.mdb 之设定<br>Dim pplConnStr As String  '设定资料库开启变数<br>Dim mpplPath As String    '设定路径<br>Dim mPW As String         '设定密码变数<p>'以下是 eMbox.mdb 之设定<br>Dim eMConnStr As String<br>Dim eMpath As String<p><br>  Me.Height = Screen.Height * 0.7<br>  Me.Width = Screen.Width * 0.7<br>  Me.Move (Screen.Height - Me.Height) \ 2, (Screen.Width - Me.Width) \ 2<br>  cmdButton ("Clear")<br>  <br>  mPW = "zhenguan"<br>  <br>  eMpath = App.Path + "\mdb\eMbox.mdb"<br>  eMConnStr = "Provider=Microsoft.jet.OLEDB.3.51" & _<br>            ";data source=" & eMpath<br>  eMConn.Open eMConnStr<br>  eMrseMBox.CursorLocation = adUseClient<br>  '开启 eMbox.mdb<br>  eMrseMBox.Open "eMbox", eMConn, adOpenKeyset, adLockPessimistic<br>  '开启 counter.mdb<br>  eMrsCounter.Open "Counter", eMConn, adOpenKeyset, adLockPessimistic<br>  <br>  <br>  mpplPath = App.Path + "\mdb\people.mdb"<br>  pplConnStr = "Provider=Microsoft.jet.OLEDB.3.51" & _<br>               "; jet OLEDB:Database Password= " & mPW & _<br>               "; Data Source=" & mpplPath<br>  <br>  pplConn.Open pplConnStr   '开启资料库<br>  pplRS.CursorLocation = adUseClient<br>  pplRS.Open "NameComm", pplConn, adOpenKeyset, adLockPessimistic<br>  '开启资料表<br>  <br> pplRS.Index = "pplSeq"    问题出在这里<br>  <br>    Do While Not pplRS.EOF<br>     If pplRS.Fields("MOC") = "电邮" Then<br>        cboContact.AddItem pplRS.Fields("Cname") + Str(pplRS.Fields("pplseq"))<br>        cboeMaddress.AddItem pplRS.Fields("NOC")<br>     End If<br>     <br>     pplRS.MoveNext<br>     <br>  Loop<br>  <br>End Sub<p>如果能够得到您的帮助,那就太感激了!<br>我的e-mail是:forestlsw@hutchcity.com<p><p><p><p>: : 本人在VB5下曾经用下列方式开启index,但在VB6下开启郤显示”不支援<br>: : ”等错误讯息,请问各位高手应如何解决?<br>: : VB5下使用index之情况:<br>: : rs.index="index 名称"<p>: : 谢谢!<p>: :::既然vb6有的话,VB6也应该会有支援才对,可否将程式<br>: 或资料库传给小女子看看(Luo570@ms31.hinet.net)!!!<p>
<br>
<br><hr size=7 width=75%><p>
<a name="followups">Follow Ups:</a><br>
<ul><!--insert: 16353-->
</ul><!--end: 16353-->
<br><hr size=7 width=75%><p>

</body></html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?