10498.html

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

HTML

26 行

<html>
  <head>
    <title>Can't use index/seek under odbc conn with MS SQL?</title>
  </head>
  <body bgcolor="#FFFFFF" vlink="#808080">
    <center>
      <h1>Can't use index/seek under odbc conn with MS SQL?</h1>
    </center>
<hr size=7 width=75%>

<hr size=7 width=75%><p>
Posted by <a href="mailto:richard.pang@hongkong.com">Richard Pang</a> on March 02, 1999 at 10:39:20:<p>
My Front-end VB 5.0 sp3 with DAO3.5, ODBC; Back-end MS SQL server 6.5. I mainly<br>use VB jet engine rather than ODBC Direct in data control.<p>My problem is I cannot explict create a recordset by  dbOpenTable to utilize<br>the index method of recordset, even I have explictly created a jet<br>workspace.<br>ie.<br>Set db = ws.OpenDatabase("", False, False, _<br>    "ODBC;dsn=mydata;Database=pubs;uid=sa;pwd=")<br>X: Set rs = db.OpenRecordset("dbo.authors", dbOpenTable)<p>I find I can't use the seek and index method to speed up my application. Is<br>the Table type not allowed in this situation and what is the solution if no<br>index can use instead of "FindFirst"?<p>Thank you for your help<br>Richard<p>
<br>
<br><hr size=7 width=75%><p>
<a name="followups">Follow Ups:</a><br>
<ul><!--insert: 10498-->
<!--top: 10502--><li><a href="10502.html">本来就不行</a> <b>小吴</b> <i>11:22:10 3/02/99</i>
(<!--responses: 10502-->0)
<ul><!--insert: 10502-->
</ul><!--end: 10502-->
</ul><!--end: 10498-->
<br><hr size=7 width=75%><p>

</body></html>

10498.html - 源码说明

本页面展示了「以电子书的形式收集了VB一些常见问题解决方法,可以很方便的查找自己需要解决的问题.对一些VB初学者很用.」中的 10498.html 源码文件，采用 HTML 编程语言编写，共 26 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫开发者社区收录了大量与VB相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C

搜索代码Ctrl + F

全屏模式F11

增大字号Ctrl + =

减小字号Ctrl + -

显示快捷键?