11864.html

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

HTML
30
字号
<html>
  <head>
    <title>资料库查询存档的问题...依然解决不了</title>
  </head>
  <body bgcolor="#FFFFFF" vlink="#808080">
    <center>
      <h1>资料库查询存档的问题...依然解决不了</h1>
    </center>
<hr size=7 width=75%>

<hr size=7 width=75%><p>
Posted by 林文芳 on April 11, 1999 at 22:33:31:<p>
Dim rs As Recordset<br>Dim db As Database<p>Set db = DBEngine.Workspaces(0).OpenDatabase("f:\test.mdb")<br>Set rs = db.OpenRecordset("测试")<br>Set Data1.Recordset = rs<br>Set rs = db.OpenRecordset("select * into [查存] from [测试] where [AAA] > 5")<br>Set Data1.Recordset = rs<p>执行后居然会出现"无效的操作"的错误讯息...<br>但若是改成<br>Set rs = db.OpenRecordset("select * from [测试] where [AAA] > 5")<br>就可以正确执行...<br>但我就是想要将查询后的资料另存在[查存]这个Table中<br>语法也没有用错ㄚ...请各位帮帮忙...救救我吧!!!
<br>
<br><hr size=7 width=75%><p>
<a name="followups">Follow Ups:</a><br>
<ul><!--insert: 11864-->
<!--top: 11924--><li><a href="11924.html">Re: 资料库查询存档的问题...依然解决不了</a> <b>柏先生</b> <i>14:11:07 4/13/99</i>
(<!--responses: 11924-->0)
<ul><!--insert: 11924-->
</ul><!--end: 11924-->
<!--top: 11865--><li><a href="11865.html">Re: 资料库查询存档的问题...依然解决不了</a> <b>andyLin</b> <i>23:49:53 4/11/99</i>
(<!--responses: 11865-->0)
<ul><!--insert: 11865-->
</ul><!--end: 11865-->
</ul><!--end: 11864-->
<br><hr size=7 width=75%><p>

</body></html>

⌨️ 快捷键说明

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