📄 3286.html
字号:
<html>
<head>
<title>Re: VB recordset SQL return code</title>
</head>
<BODY BACKGROUND="" BGCOLOR="white" TEXT="black" LINK="red" VLINK="#808080" ALINK="">
<center>
<h1>Re: VB recordset SQL return code</h1>
</center>
<HR><p>
Posted by <a href="mailto:jwh@ms1.hinet.net">纪文和</a> on June 17, 1998 at 05:21:13:<p>
In Reply to: <a href="3282.html"><b>Re: VB recordset SQL return code</b></a> posted by David Wong on June 17, 1998 at 01:58:04:<p>
若您要用 Execute 算出 Select 恐怕不行, 若是 Action Query 可用<br>Db.RecordsAffected 算出.<p>用 ExecuteSQL Method 是可以算笔数的, 但是也只能用在 Action Query, <br>即 Delete/Update..., 而 Select 是算不出来的. (传回值即笔数)<p>您若用以下方法也可以:<br> Dim ss as snapshot<br> Set ss = db.createsnapshot("select * from staff where staff_code = 'A'")<br> if ss.recordcount = 0 then<br> 资料笔数 = 0笔<br> else<br> ss.movenext<br> 资料笔数 = ss.recordcount<br> end if<br>
<br>
<p>
<a name="followups">Follow Ups:</a><br>
<ul><!--insert: 3286-->
<!--top: 3310--><li><a href="3310.html"><b>Re: VB recordset SQL return code</b></a> David Wong <i>02:42:05 6/18/98</i>
(<!--responses: 3310-->0)
<ul><!--insert: 3310-->
</ul><!--end: 3310-->
<!--top: 3309--><li><a href="3309.html"><b>Re: VB recordset SQL return code</b></a> David Wong <i>02:41:40 6/18/98</i>
(<!--responses: 3309-->0)
<ul><!--insert: 3309-->
</ul><!--end: 3309-->
<!--top: 3299--><li><a href="3299.html"><b>Re: VB recordset SQL return code</b></a> David Wong <i>20:28:20 6/17/98</i>
(<!--responses: 3299-->0)
<ul><!--insert: 3299-->
</ul><!--end: 3299-->
</ul><!--end: 3286-->
<br><HR><p>
</body></html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -