3179.html
来自「以电子书的形式收集了VB一些常见问题解决方法,可以很方便的查找自己需要解决的问题」· HTML 代码 · 共 22 行
HTML
22 行
<html>
<head>
<title>Re: 请问错在那里 ?</title>
</head>
<BODY BACKGROUND="" BGCOLOR="white" TEXT="black" LINK="red" VLINK="#808080" ALINK="">
<center>
<h1>Re: 请问错在那里 ?</h1>
</center>
<HR><p>
Posted by <a href="mailto:koi@arco.org.tw">Koi</a> on June 10, 1998 at 01:53:02:<p>
In Reply to: <a href="3160.html"><b>请问错在那里 ?</b></a> posted by 普罗米修斯 on June 09, 1998 at 10:48:01:<p>
: 执行以下程式码 , 出 " 形态不符 " :<p>: Dim SQL As String<br>: Dim Rate As Single<br>: <br>: Dim db As Database<br>: Set db = OpenDatabase("C:\AA\AA.MDB")<br>: <br>: Rate = Form.Text3<br>: <br>: SQL = "UPDATE SQLTABLE SET Price = Price * " & " " + Rate + " " & " WHERE Currency = 'HK$'"<br>: db.Execute SQL<p>: 请问错在那里 ?<p>Rate 是 Single, 而 "+" 只能用在纯文字字串的相加, 不同型态的资料间<br>要当成字串相加, 要用 "&".<br>
<br>
<p>
<a name="followups">Follow Ups:</a><br>
<ul><!--insert: 3179-->
</ul><!--end: 3179-->
<br><HR><p>
</body></html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?