vb双引号的问题strSQL = "select * from 表1 where 编号=" & Val(Text5.Te

来源：学生作业帮编辑：作业帮分类：语文作业时间：2024/05/16 20:08:20

vb双引号的问题
strSQL = "select * from 表1 where 编号=" & Val(Text5.Text) & ""和
rs.filter="uname=' " & TXTCONDITION.text & " ' "
这里第一句为什么给Val(Text5.Text)加引号?而第二句为什么是' " & TXTCONDITION.text & " ' 这样的格式?

你断句断的不对!
vb中字符串拼接用的是 “串A & 串B & 串C” 的格式,你按&断开来看就清晰了!
----------
1) "select * from 表1 where 编号=" & Val(Text5.Text) & ""
^-----------串A ^--------串B ^---串C
展开后结果可能是：select * from 表1 where 编号=1
2) "uname=' " & TXTCONDITION.text & " ' "
^----串A ^-----串B ^---串C
展开后结果：uname='abcd'

vb双引号的问题strSQL = "select * from 表1 where 编号=" & Val(Text5.Te SQL >select count(*) from Teacher where teacherCode=? and te vb 如select * from a where b=' "+###1+" '的语句怎么写才可以筛选两个词 select * from book where 1=1 英语翻译select top 4 * from shop_books where anclassid = (select 在VB 语句中 x = Val(Text1.Text) Val select A,B,C,D=(select count(*) from 表 where c=a.a and b=a.b $query = "SELECT * FROM student_info WHERE name = '".$login_ String sql = "select * from tb_consumer where account='" + a 英语翻译strQuery = "select * from suppliers where CompanyName='" sql6 = "select * from khxx_data where" + Trim(SSBox.Text) + if not exists (SELECT * From TA_ARTIFICER Where ARTID = @Art