📄 3246.html

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

💻 HTML

字号:

<html>
  <head>
    <title>Re: &quot;Select * where .......&quot;长度太长整么办?</title>
  </head>
  <BODY BACKGROUND="" BGCOLOR="white" TEXT="black" LINK="red" VLINK="#808080" ALINK="">
    <center>
      <h1>Re: &quot;Select * where .......&quot;长度太长整么办?</h1>
    </center>

<HR><p>
Posted by <a href="mailto:jwh@ms1.hinet.net">纪文和</a> on June 15, 1998 at 09:17:03:<p>
In Reply to: <a href="3239.html"><b></b></a> posted by 霈捷 on June 15, 1998 at 01:04:01:<p>
这个问题其实很简单, 您只要稍微换个角度想就可以了!<br>例如: Set ss = Db.CreateSnapshot("Select * from table1 where field1 = 'aaa' and field2 = 'bbb' and ...")<p>您可以改成以下方式:<br>Dim wsql as string<br>wsql = "Select * from table1 where "<br>wsql = wsql & "field1 = 'aaa' and "<br>wsql = wsql & "field2 = 'bbb' and "<br>wsql = wsql & "field3 = 'ccc' and "<br>wsql = wsql & "...."   您想多长就可多长<br>Set ss = Db.CreateSnapshot(wsql)
<br>
<p>
<a name="followups">Follow Ups:</a><br>
<ul><!--insert: 3246-->
<!--top: 3251--><li><a href="3251.html"><b>建立 query 或使用 stored procedure</b></a> 小吴 <i>18:44:18 6/15/98</i>
(<!--responses: 3251-->1)
<ul><!--insert: 3251-->
<!--top: 3283--><li><a href="3283.html"><b>Re: 谢谢！我再试试看。</b></a> 霈捷 <i>02:36:33 6/17/98</i>
(<!--responses: 3283-->0)
<ul><!--insert: 3283-->
</ul><!--end: 3283-->
</ul><!--end: 3251-->
</ul><!--end: 3246-->
<br><HR><p>

</body></html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -