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 + -
显示快捷键?