两条语句的区别?If Combo1.Text = "进价" Or Combo1.Text = "数量" Or Combo1.Text = "金额" ThenSet rs = conn.Execute("select * from purchase where " & Combo1.Text & "=" & Combo2.Text)ElseSet rs = conn.Execute("select * from purchase where "

来源：学生作业帮助网编辑：作业帮时间：2024/11/16 14:52:17

两条语句的区别?If Combo1.Text = "进价" Or Combo1.Text = "数量" Or Combo1.Text = "金额" ThenSet rs = conn.Execute("select * from purchase where " & Combo1.Text & "=" & Combo2.Text)ElseSet rs = conn.Execute("select * from purchase where "
两条语句的区别?
If Combo1.Text = "进价" Or Combo1.Text = "数量" Or Combo1.Text = "金额" Then
Set rs = conn.Execute("select * from purchase where " & Combo1.Text & "=" & Combo2.Text)
Else
Set rs = conn.Execute("select * from purchase where " & Combo1.Text & "='" & Combo2.Text & "'")
End If
请问("select * from purchase where " & Combo1.Text & "=" & Combo2.Text) 与
("select * from purchase where " & Combo1.Text & "='" & Combo2.Text & "'") 的区别在哪里?

两条语句的区别?If Combo1.Text = "进价" Or Combo1.Text = "数量" Or Combo1.Text = "金额" ThenSet rs = conn.Execute("select * from purchase where " & Combo1.Text & "=" & Combo2.Text)ElseSet rs = conn.Execute("select * from purchase where "
区别就在于参数的数据类型
("select * from purchase where " & Combo1.Text & "=" & Combo2.Text)
此时的Combo2.Text 是数字型
这句等同于
("select * from purchase where " & Combo1.Text & "=" & Combo2.Text&")
Set rs = conn.Execute("select * from purchase where " & Combo1.Text & "='" & Combo2.Text & "'")
此时的Combo2.Text 是文本型
原代码中的判断是为了区别数据类型
这里就要讲一下 ' 和 " 区别
在SQL 语句里 ' 是使用在文本型中如 '文本' '张三'
" 是用在数字型中如 "12" "45"
值得注意的是 '12' 和 "12" 是有本质不同的前面的是文本不能加减运算; 后面"12" 是数字型可以加减运算
##### 帮你注释一下吧 #####
If Combo1.Text = "进价" Or Combo1.Text = "数量" Or Combo1.Text = "金额" Then '//判断选择的是进价或数量或金额则执行以下操作
Set rs = conn.Execute("select * from purchase where " & Combo1.Text & "=" & Combo2.Text) '// 因为进价或数量或金额都是数字型(后面可能要进行加减运算)所以执行这条.
Else
Set rs = conn.Execute("select * from purchase where " & Combo1.Text & "='" & Combo2.Text & "'") '//其它的应该是文本型所以执行这条.
End If

两条语句的区别?If Combo1.Text = 进价 Or Combo1.Text = 数量 Or Combo1.Text = 金额 ThenSet rs = conn.Execute(select * from purchase where & Combo1.Text & = & Combo2.Text)ElseSet rs = conn.Execute(select * from purchase where c++中while语句与if语句的区别是什么, te amo 和te quiero的区别请教下面VB 代码的意思 Private Sub Command1_Click() If Combo1.Text And Combo2.Text And C 批处理的问题语句是否可以并列,例如 if 条件成立是执行多条语句if 34 lss 2 echo 2222if 2 lss 1成立时我希望它执行两条或多条语句例如echo 2222和echo 6666（当然可以echo 2222 6666,但我只是以此举例）请问条件表达式“?:”和if+else条件语句的区别? 复合语句是由两条或两条以上的语句加上花括号{}组成的.它对外相当于几条语句? C语言的分支语句中,if()...if()...else...和if()...else if()...else...两者有什么区别? delete from和delete * from 的区别小弟在编程时遇到了一个问题,工具是vb6.0,数据库是SQL2000,想实现删除用户表里面选中用户ID的全部信息,在语句sql=delete * from 用户表 where 用户名='& combo1.text &'时如何区别含有if的条件语句与含有if的虚拟语气的句子呢 C++的push_back和back有什么区别RT.刚才看《C++标准程序库》看到了两条语句：“coll.push_back()（coll是vector容器的对象）和”coll.back().请问这两条语句有什么不同啊? 多个if语句和else if有什么区别? 西班牙语Te Quiero 与 Te amo的区别都是我爱你的意思?请问区别呢? Pascal里If语句Then后面的语句加Begin和End和不加有什么区别吗? VB里的问题我这段查询是在一个文本框里显示的.我想改成表格形式的.Private Sub Command2_Click()'查询If Combo1.Text = ThenMsgBox 你没有选择查询方式,请选择!,16,错误提示!Exit SubEnd IfIf Combo1 全部记 VHDL语言怎么理解并行语句和PROCESS的区别 IF怎么用求详解 VB问题Private Sub Command1_Click()Private Sub Command1_Click()Dim i%For i = Combo1.ListCount - 1 To 0If Combo1.Selected(i) ThenList1.AddItem Combo1(i)End IfNext i这个代码如何改 vf代码 if juststem(allt(thisform.text1.value))allt(thisform.combo1.