20036.html

来自「VB技巧问答10000例,是一个教程」· HTML 代码 · 共 23 行

HTML
23
字号
<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 <a href="mailto:styler33@ms26.hinet.net">styler</a> on October 12, 1999 at 16:24:55:<p>In Reply to: <a href="20033.html">简单搜寻的问题......</a> posted by 初学者 on October 12, 1999 at 14:48:02:<p>: 请问各位网友:<br>:     我有一个整数型态的变数(temp),我要如何撰写sql语法,才能搜寻此变数所存之值.....ex:"select * from dbname where filesname=temp"<br>:                                      ~~~~~~~~~~~~~~~~<br>: 在上述标底线的地方应如何写呢??????谢谢.....<br>数值型态时<br>SQL = "select * from dbname where filesname= " & temp<br>字串型态时(加单引号)<br>SQL = "select * from dbname where filesname= '" & temp & "'"<br>若为日期型态则将单引号(') 改为 井字号 (#)<p><br><br><hr size=7 width=75%><p><a name="followups">Follow Ups:</a><br><ul><!--insert: 20036--></ul><!--end: 20036--><br><hr size=7 width=75%><p></body></html>

⌨️ 快捷键说明

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